Is there a way to select columns with html tags in them in MySQL?

Question

I have a database where some columns have HTML tags in them, IE

Rot<sub>1</sub>

I try running queries, like

SELECT Rot<sub>1</sub> FROM chem.thermTable;

But I get an error message in my SQL syntax. Putting the column name in quotes simply returns the column name. Typing

SELECT * FROM chem.thermTable;

Works but returns other values I don't need as well. I searched and haven't found any solutions. Thanks for your help!

Edit: I am trying to query

SELECT Method,Basis,Rot<sub>1</sub> from chem.thermtable;

Why the hell you want to put HTML tags in column name, at first place... This might bring you a lot of problems in future. — Rolice
– Rolice, Commented May 22, 2014 at 17:29

alepage · Accepted Answer · 2014-05-22 17:26:09Z

1

You must use back quotes around the column name like this :

SELECT `Rot<sub>1</sub>` FROM chem.thermTable;

IMHO, this a not a clean column name and you should consider renaming it.

answered May 22, 2014 at 17:26

alepage

3261 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3051132 Over a year ago

Thanks! That seems to have done it. I will consider changing the column names too.

SidF · Accepted Answer · 2014-05-22 17:22:32Z

0

Are you asking for this?

SELECT ColumnNameX, ColumnNameY, ColumnNameZ FROM chem.thermTable;

Where you'd change the ColumnName X, Y, and Z to be the column names you want. If not, you should perhaps clarify your question with an example of a few rows worth of data.

answered May 22, 2014 at 17:22

SidF

17310 bronze badges

Collectives™ on Stack Overflow

Is there a way to select columns with html tags in them in MySQL?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related