"Jens Kisters" <[EMAIL PROTECTED]> wrote:
> Hi there, is there a possibility to use MySQL's MATCH ... AGAINST to
> look for a string like "foo bar" ?
>
> if i MATCH keyname AGAINST ('foo bar') i get resuts that match foo or
> bar, but not both of them separated by a space.
>
> My guess is that the organization of the index doesn't allow this kind
> of search as it's based on single words , but maybe one of you has a
> better idea than
> to select the rows that contain both and hit those with LIKE '%foo bar%'
Perhaps you should ask on the mysql list.
List-Subscribe: <mailto:[EMAIL PROTECTED]>
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
--
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]
