>Hi
>
>I have posted this before. You can do an AND search by using the IF()
>function.
>Its messy in the query but it works.
>Here an example of my select query - 3 inputs are checked as AND:
>
>
>SELECT author, title, year, recommend, copy, publ_desc, publ_loc,
>CEILING(IF(MATCH author AGAINST ( 'Adams') > 0, IF(MATCH title AGAINST
>('Places') > 0, IF(MATCH publ_desc AGAINST ('Society') > 0, (MATCH author
>AGAINST ('Adams') + MATCH title AGAINST ('Places') + MATCH publ_desc
>AGAINST ('Society')), 0), 0), 0)) as x FROM books, publ WHERE publ_id =
>pub_id ORDER BY x DESC
>
>Hope this helps!
>
>Cheers, Nessi
>
>
>At 22:22 26/06/01 , you wrote:
>>Ok,
>>
>>The message set that I noticed this morning sparked my interest in this.
>>Currently I'm developing a search engine that will utilize mysql's
>>fulltext match technology. The problem that i've run into is, I can't
>>seem to find any documentation on how to force an AND search with in
>>MATCH AGAINST syntax, As far as I can tell this is `OR' only. Has is
>>there
>>an option to force AND? If so could this please be appended to the
>>manual
>>under the `MySQL Full-text Search' section. Thanks.
>>
>>---------------------------------------------------------------------
>>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
---------------------------------------------------------------------
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
