Linux Today: Linux News On Internet Time.

More on LinuxToday

ONLamp.com: MySQL FULLTEXT Searching

Jun 30, 2003, 07:00 (3 Talkback[s])
(Other stories by Joe Stump)


Desktop-as-a-Service Designed for Any Cloud ? Nutanix Frame

"Have you ever wanted to search text stored in your database, but couldn't figure out how to do it efficiently? Are you lazy like me and don't enjoy maintaining reverse indexes, dictionaries, and word scores? You're in luck. The release of MySQL 4.0 has made searching text stored in databases available to the masses.

"MySQL has had FULLTEXT searching in one form or another since version 3.23.23. FULLTEXT indices in MySQL allow database administrators and programmers to designate any character-based field (CHAR, VARCHAR, or TEXT) as a FULLTEXT index, which allows for complex text searching against data stored in those fields.

"This feature is not to be confused with the LIKE function in MySQL. LIKE works more along the lines of a regular expression. On the other hand, FULLTEXT indices are fully indexed fields which support stopwords, boolean searches, and relevancy ratings..."

Complete Story

Related Stories: