Dear colleagues, I am trying to build a sub-corpus based on this sql query:
SELECT * FROM ISIABSTRACT WHERE data like %pesticide%
and it does not work, I get an error message. I have also tried to query the corpus using the field "condition" but it does not work either. What may be the problem?
Thank you so much.Thank you so much for your help!
I think something is missing in the query: you need to add single quotes around ‘%pesticide%’