Search code examples
sqlcql

CQL Query on a column with a whitespace

I wish to do a SELECT query but unfortunately, the database I am working on has a column with whitespace.

Example of query (partial) :

"WHERE My Column = value"

CQL says that

the column name 'My' doesn't exist in the database.

How can I make CQL understand that it has to look for the column "My Column"?

Thank you in advance.

Solution

  • I found what worked for me :

    'WHERE "My Column" = value'