Mysql Query Column Name Substring

Is it possible to combine the use of back ticks ` with the substr() function? I have column names with hyphens '-' which require the use of backticks to query but seems like I cann

Solution 1:

You cannot do what you want with a simple SQL statement. When you use abc-def-ghi, you get the value of the column, not the name.

A SQL SELECT statement returns a fixed set of columns with a fixed set of names, You cannot select names that way.

If you want to do something like this, then you would need to use dynamic SQL (prepare and exec). However, I suspect that you might have a poor data model. You might want to ask another question, show the table layout, and ask if that is a reasonable data structure for what you are trying to do.