What is the command of searching this thing in a table of mysql?
For example, I have a record mohan in one of my mysql-table, and when i search the database by the name mohan, it returns the rows wherever the column has name mohan in it.
select * from names where name like '%mohan%'
This is very simple.
But I felt said when I searched by the name moh an, there was no rows returned.
and the same thing happened when i searched moh-an.
select * from names where name like '%mo han%'
select * from names where name like '%mo-han%'
Is there any way to search all the characters in that column name and figure out what i want?