One way you can try doing this is by implementing phrase searching after
the fulltext search:
"...WHERE MATCH author AGAINST('ian fleming')
AND LOCATE('ian fleming', LOWER(author)) > 0
I think this will work.
Barry Wiegan
> At 17:09 19/06/01 , you wrote:
> >Hi. We're using full text searches to search a database of books.
> >
> >In the absence of AND searches, promised for MySQL v4 (e.g., "+joe
> >+johnson"), we're doing splitting and doing multiple full text matches.
> >
> >For example, charles dickens to find all books matching charles dickens,
> >the query is done WHERE MATCH author AGAINST('charles') AND MATCH author
> >against('dickens').
> >
> >Unfortunately, for words shorter than four letters the query is ignored
> >(presumably because it is assumed that it would return a lot of results),
> >so a search for Ian Fleming returns zero results.
> >
> >Can anyone suggest how to make this work properly?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
