SELECT status
FROM offline_bookings
I want to retrieve this SQL code but it doesn't work.
status is keyword but it is a column name also
is there a way to do it ?
SELECT status
FROM offline_bookings
I want to retrieve this SQL code but it doesn't work.
status is keyword but it is a column name also
is there a way to do it ?
That's SQL rather than Metabase.
You need to use either "status" or [status] depending upon your database.
I tried both "status" or [status] but did not work
My DB is MySQL
In MySQL, you use "status"
MySQL uses backticks, so you would use `status`
Worked for me
many thanks, it worked