Re: keyword search
| From: | Intruder | Date: | Sat, 13 Oct 2001 08:26:36 +0000 |
| Subject: | Re: keyword search | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-13303@lists.php.net to get a copy of this message | ||
SP> Does anybody know how to program a "keyword search" through a
SP> database?
SP> Because at this moment my search string does only display the exact word
SP> that I typed and leaves all other records away. What I really want is
SP> that PHP will look for if my search string excist in the data base and
SP> shows all the records that matches the contens. (I hope I can make
SP> myself clear!)
SELECT *
FROM table
WHERE keyword_field LIKE "%$keyword_value%"
Of course you can make it more complicated! ;))