sql query does to build sub-corpus does not work

CorText Manager Q&A forum › Category: Data exploration › sql query does to build sub-corpus does not work
0 Vote Up Vote Down
orianabras asked 5 years 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 5 years ago

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