Searching name from database

Question

I have the name in mysql database table like Mohan Krishna. How we can search for that name using php with searching like mohankrishna name?

Answer 1

SELECT * FROM tablename
WHERE LOWER(REPLACE(name,' ','')) LIKE LOWER('%mohankrishna%')

Answer 2

I'm not 100% sure, but could be a good approach.

One way would be, using the full text functionality of MySQL.

Another way by using LIKE in your SELECT-query just like.

SELECT * FROM users WHERE username LIKE "mohankrishna";

But I'm not really familiar with this and I don't know how tolerant MySQL is to give you the exact record.