Search database with two words
Totally new to mysql.
I hope this is easy.
Just want to search for results with
Fire AND poi in the field.
So this would exclude results with fire alone, or poi alone.
SELECT * FROM isc_products WHERE prodname like '%$search%' LIMIT 100
I try the AND which brings back results with either.
Hope this makes sense and is an easy thing to achieve.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)