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.