Re: sql: LIKE
| From: | CC Zona | Date: | Thu, 11 Jan 2001 09:52:48 +0000 |
| Subject: | Re: sql: LIKE | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5795@lists.php.net to get a copy of this message | ||
In article <14589.979197692@www25.gmx.net>, venome@gmx.net wrote:
> "SELECT bar FROM foo WHERE bar LIKE '%foo%'" should return something like
> the order
>
> bar
> ---------------------------
> 'foo' (exact match)
> 'the foo is a foo is a foo' (3 matches)
> 'have you seen the foo?' (1 match)
What DBMS? In recent versions of MySQL "fulltext" indexing was added; it
does approximately what you describe.
--
CC