REST API: SELECT * FROM Answer WHERE keyword LIKE
Is there a reason why I can't use a WHERE clause on the "Keywords" column in the Answer table? I've tried this using the Connect Object Explorer and directly using the RestAPI.
Also I've noticed the LIKE is very hit and miss. For example, there are answers with the words 'wifi' and 'add' in the Summary column but if I do 'SELECT * FROM Answer WHERE summary LIKE '%add%', I get no results - even though I KNOW there should be.
When I do 'SELECT * FROM Answer WHERE summary LIKE '%wifi%', it finds the correct amount of results.