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 cannot do something like:
SELECT substr(`abc-def-ghi`,1,5) FROM tableName
Where the aim is to select all rows from columns starting with abc-d. Unfortunately changing/removing the hyphens is not an option.
See Question&Answers more detail:os