Reserved words

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`

1 Like

Worked for me :wink:

1 Like

many thanks, it worked