How do I search on numerous different values that are in one field? For example, I have a field named "countries" in my database and some cells have four or five values. When I want to search on these after they've been withdrawn from the database I get a URL like this... http://journeys-intl.com/take_out/search_reviews_static.php?country=%Namibia%2C+Botswana%2C+Zimbabwe%2C+South+Africa%
I really do want to search on that many different values but it seems to confuse the db. Is there any way to do this properly
Read what the manual says about the "in" keyword:
select * from mytable where country in ('Namibia','Botswana')
