How to search a 'near word' in MySQL?

Question

For example, i want to search a word 'marple', this should return row with near or exact word like 'marble','maple','marple', etc...

How to do it in mysql query? or better give word suggestion if any?

Thanks,

Answer 1

In MySQL you can try use soundex function, but it's not a real solution. Use Sphinx or Lucene.

Answer 2

SOUNDEX function.

"Two strings that sound almost the same should have identical soundex strings."

Answer 3

Hello,

You can use this

$sql = "select * from tbl_name where your_field like '%your search keyword%'";