RE: [PHP-DB] (reverse) matching like LIKE?
| From: | John W. Holmes | Date: | Mon, 14 Oct 2002 15:22:44 +0000 |
| Subject: | RE: [PHP-DB] (reverse) matching like LIKE? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22378@lists.php.net to get a copy of this message | ||
> When if have the keyword 'msq' i can match the field 'mysqldata'
> SELECT * FROM table WHERE field LIKE "$keyword%"
> But how do i get a match when the keyword is 'mysqldatabase' and the
field
> 'mysql'? (TRUE cause keyword contains 'mysql').
>
That'll never work unless you know where to divide up the "keyword" into
separate words. The way you want it, why not return everything with an
"a" in it, since the keyword contains 'a'??
---John Holmes...