Hi there,
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.
Thanks heaps