I am using Codeigniter framework. I have a database table 'product', it has a column 'title' and the title is 'Canon Digital SLR Camera'.
I want to search my table with the text 'cannon' (double n) and it should return 'Canon Digital SLR Camera'.
Currently I am using
SELECT * FROM product WHERE title SOUNDS LIKE 'Cannon Dgtal SLR Cemera'";
and it is working fine. But I don't want to write long title, I just want to write 'cannon' (misspelled word) and it should return full product title.
How can I achieve this? Any help would be really appreciated.