MySQL with php

[email protected] ("Jan") Sun, 22 Sep 2002 18:53:05 +0200
Newsgroups php.lang
Message-ID <[email protected]>
Hello
i've a simple question i think ;)
if i want to do a query with 2 keywords in a MySQL database, how do i write
it in my script?

ie.  I want to search for name=peter pan   with the keywords "pan" and
"peter"

I thought it's like this:
$query=SELECT ... FROM ... WHERE name LIKE '%pan%' AND LIKE '%peter%'

but this isn't working :(

hope somebody can help me out.

thanks,


Jan