Search database with two words

[jason3w]

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
Jason

[codefish]

Read more about the Boolean fulltext - http://dev.mysql.com/doc/refman/5.5/...t-boolean.html