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