Skip navigation links

Contact Sales

USA - Toll Free: +1-866-221-0634
USA - From abroad: +1-408-701-9009
USA - Subscription Renewals: +1-866-830-4410

Latin America: +1 512 535 7751
UK: +44 845 399 1124
Ireland: +353 1 6919191
Germany: +49 89 420 95 98 95
France: +33 1 70 38 72 00
Sweden: +46 730 207 871
Benelux: +358 50 5710 528
Italy: +39 06-99268193
Israel: +358 50 5710 528
Spain & Portugal: + 34 933905461
Other EMEA countries: +353 1 6919191

Asia Pacific: +81 3 5918 7507

Contact Us Online »

Learn about new MySQL releases, technical articles, events and more.

Subscribe Now »

From the Manual: MySQL Full-text Search

I need to store documents into database and I need to be able to provide full text searches to those documents. Can I do that with MySQL?

Yes, you can do that. As of Version 3.23.23, MySQL has support for full-text indexing and searching. Full-text indexes in MySQL are an index of type FULLTEXT. FULLTEXT indexes are used with MyISAM tables only and can be created from CHAR, VARCHAR, or TEXT columns at CREATE TABLE time or added later with ALTER TABLE or CREATE INDEX.

You can read more about the MySQL Full Text Search from http://www.mysql.com/doc/en/Fulltext_Search.html