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