Posted by Da Dimmi de wit on 01/12/07 23:02

On Fri, 12 Jan 2007 15:15:39 -0000, "Paul Lautman"
<paul.lautman@btinternet.com> wrote:

>Da Dimmi de wit wrote:
>> I have a database table that I need to query specific keywords from.
>> I would like to do so using a + or -.
>>
>> -DDW
>
>Look at the FULLTEXT facilities
>

Ah yes, Boolean mode in FULL Text.

mysql> SELECT E.entryID,E.title,C.name
-> FROM blog_entries AS E, blog_categories AS C
-> WHERE E.categoryID=C.categoryID AND
-> MATCH (E.title,E.entry) AGAINST ('+vacation -washington'
IN BOOLEAN MODE) AND
-> E.categoryID=1;

http://www.onlamp.com/pub/a/onlamp/2003/06/26/fulltext.html

I believe this is what I was searching for.
Now I just need to confirm BOOLEAN works with words like 'the' and
'when' and doesn't drop them like MATCH does in FULLTEXT.


-Thanks.

[Back to original message]