ignore dots and commas while making like query in mysql

Question

I have to do a fuzzy kind of match in a column in mysql I have a column which has fields like this

column_name
-----------
A.P Name1
Name2, allias
NAME1
Name2

For case insensitivity I have done this

select coulmn_name from table where column_name like 'name' COLLATE UTF8_GENERAL_CI;

I would like to provide a search box where a user can type ap and my query would produce A.P Name1 as the output from the table. How can I ignore . & , in mysql like statement

Answer 1

You can use REPLACEfunction of mysql

Check this to to understand this better.