I have data like this: column 1: “id1” column 2: “(test)” when I use wix-data-sql where condition:
SELECT column1 column2
from data WHERE column2 = “(test)”
I get no result. I think this is because of the brackets because other data without brackets work. Do you need to escape this somehow? I tried javascript escape function.