Is it possible to use a LIKE with an IN statement? The following example might make this more clear.
SELECT stuff from joined tables
WHERE searchTerm IN (SELECT allkeywords)
What I want to want to have happen is if the keywords returned by the inner query is "barely" and the searchTerm is...
I am trying to write a very simple search page where a user can search for images stored in the database by typing a search term. Images in the database have three attributes that lend themself to searching: Category, Keyword, and Description. I want to compare the search term the user...
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.