Search for a name from the database

Question

I have a name in the database table mysql, for example Mohan Krishna . How can we search for this name using php with a search like mohankrishna name?

Answer 1

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

Answer 2

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

One way is to use the full-text functionality of MySQL.

Another way using LIKE in your SELECT -query is exactly the same.

SELECT * FROM users WHERE username LIKE "mohankrishna";

But I am not very familiar with this, and I do not know how tolerant MySQL should give you an accurate record.

Answer 3

 select * from table where where replace(name," ","") like '%mohankrishna%' 

Answer 4

for example: SELECT column_1 from prefix_my_table WHERE column_2 LIKE '%Mohan%';