In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
