Date: 05/11/05 (MySQL Communtiy)    Keywords: mysql, sql

Hi everyone,

Am using MySQL 3.23.58... we have seen that it's possible to search any touple using the regular expression either using REGEXP or LIKE.

But i want to do something like searching by phonetics... like Spellchecking and closest word. Is there any method so that it can be done through SQL query only?

For Example:
Suppose if in a table 'items' the entry in 'item_name' field is 'COMPUTER' and if the searchable text is 'KOMPUTAR' then the syntax should find the table for the entry which pronounces like 'KOMPUTAR' and it should find 'COMPUTER'...

If there's not any SQL syntax then can it be done through REGEXP? if it's so then someone please give the REGEXP for this


Thank you.

Source: http://www.livejournal.com/community/mysql/57023.html