Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MySQL Search abilities
- Thread starter aarrgghh
- Start date
Version 4.0.1+ has full-text search capabilities that you allude to.
mysql> SELECT * FROM atable WHERE MATCH (field1,field2)
-> AGAINST ('+term1 +term2 -term3' IN BOOLEAN MODE);
This capability is only provided for the MyISAM table type.
There are no versions of MySQL, AFAIK, that support
"+term +term" in the SQL WHERE clause which isn't
using a full-text search, however.
mysql> SELECT * FROM atable WHERE MATCH (field1,field2)
-> AGAINST ('+term1 +term2 -term3' IN BOOLEAN MODE);
This capability is only provided for the MyISAM table type.
There are no versions of MySQL, AFAIK, that support
"+term +term" in the SQL WHERE clause which isn't
using a full-text search, however.
- Status