Full text practices

[Craig Stadler]

I am looking for information on the proper way to code full text queries and
more information on how they work.
I am especially interested in how to code for multi word queries...

for example :

Searching for : 'today is the day'

Select * from table1 where match field1 against ('today is the day' IN
BOOLEAN MODE) ????
Select * from table1 where match field1 against ('today or is or the or day'
IN BOOLEAN MODE) ????

What is the difference between using or not using IN BOOLEAN MODE?
What is the best way to allow people to also search for "today is the day"
in quotes--- literal string...

Thanks in advance for any help.
Craig Stadler

[steve]

> I am looking for information on the proper way to code full text
queries and

more information on how they work.
I am especially interested in how to code for multi word queries...

for example :

Searching for : ’today is the day’

Select * from table1 where match field1 against (’today is the day’ IN BOOLEAN MODE) ????
Select * from table1 where match field1 against (’today or is or the or day’ IN BOOLEAN MODE) ????

What is the difference between using or not using IN BOOLEAN MODE?
What is the best way to allow people to also search for "today is the day" in quotes--- literal string...

Thanks in advance for any help.
Craig Stadler

Good reference:
http://www.databasejournal.com/featu...le.php/1578331

mysql manual had a good documentation on fulltext:
http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
Binary is also explained - follow the thread in the url above.

With fulltext, you can search for quoted strings as you have
described.

Please check out the links above. If your questions are not answered
in this thread, then query again, and I will try to help.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-Full-t...ict124191.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=413684

[CryingClinton]

I am looking for information on the proper way to code full text

queries and

> more information on how they work.
> I am especially interested in how to code for multi word queries...
>
> for example :
>
> Searching for : today is the day?
>
> Select * from table1 where match field1 against (today is the day?

IN

> BOOLEAN MODE) ????
> Select * from table1 where match field1 against (today or is or

the or day?

> IN BOOLEAN MODE) ????
>
> What is the difference between using or not using IN BOOLEAN MODE?
> What is the best way to allow people to also search for "today is

the day"

> in quotes--- literal string...
>
> Thanks in advance for any help.
> Craig Stadler

Select * from table1 where match field1 against ("+today +is +the +day?" IN
BOOLEAN MODE)

this statement requires the record contain all the 4 words.

PS, there's no relevent value will be useful coz all record returned has all
the words.

Cheers, ccton

[steve]

CryingClinton wrote:

I am looking for information on the proper way to code full text

queries and

> more information on how they work.
> I am especially interested in how to code for multi word

queries... >
> for example :
>
> Searching for : today is the day?
>
> Select * from table1 where match field1 against (today is the day? IN

> BOOLEAN MODE) ????
> Select * from table1 where match field1 against (today or is

or the or day?

> IN BOOLEAN MODE) ????
>
> What is the difference between using or not using IN BOOLEAN

MODE? > What is the best way to allow people to also search for

"today is the day"

> in quotes--- literal string...
>
> Thanks in advance for any help.
> Craig Stadler

Select * from table1 where match field1 against ("+today +is +the

+day?" IN BOOLEAN MODE)

this statement requires the record contain all the 4 words.

PS, there’s no relevent value will be useful coz all record returned has all the words.

Cheers, ccton

Sorry, it seems like I did not respond properly to your question, in
my prev. post (I hope others do).

In any case, boolean mode does not use relevancy, and what you say
above is correct.

In any case, most bulletin boards, etc. do not allow exact string
searches, and it does not seem to seriously bother their users (it
does not bother me as a user).. so I would implement that if it is a
"must have".

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-Full-t...ict124191.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=421033