in reply to Re: selecting again from a mysql database
in thread selecting again from a mysql database
Back-ticks in an SQL statement are sometimes needed around a column name if that name also happens to be a reserved keyword in SQL.
I just learned this myself recently, when I tried to inspect a table that a co-worker had created, with a column called "group" -- which is a natural enough name for a column, but you can't do a query like "select group from my_table" unless you put back-ticks around that column name, because "group" is a reserved word (as in "group by").
|
|---|