Yes, the syntax is correct. That is what I am currently using, and it works well. The main problem is that not all the records have a description, because some have sufficient information in the title, and without serching the titles also some of the record will not show up in through the search.
desc OR title LIKE "%that%" isn't valid ANSI sql
you should do as Mighty suggested and use the correct SQL syntax..
I think the reason your query is returning all records because it is looking at (desc OR title LIKE "%that%" to mean ([DESC IS NOT EMPTY] OR TITLE LIKE "%that%"
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.