sql query does to build sub-corpus does not work

ForumCategory: Errorsql query does to build sub-corpus does not work
orianabras asked 3 months ago

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!

 

Jean-Philippe Cointet Staff replied 3 months ago

I think something is missing in the query: you need to add single quotes around ‘%pesticide%’

learn about CorText scripts and share your experience