MySQL with php
| From: | Jan | Date: | Sun, 22 Sep 2002 16:53:05 +0000 |
| Subject: | MySQL with php | ||
| Groups: | php.lang | ||
| Request: | Send a blank email to php-lang+get-388@lists.php.net to get a copy of this message | ||
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