I am trying to search a mysql field which have telephone numbers. So, user can enter phones like 111 526 666 or 111-526-666 but when I search it can not locate 11152, so search string should exactly be as record is entered. I am search with simply:
phone LIKE "%'.$search_string.'"
Is there a way that we can search in fields excluding special characters? So, searching 11152 can get record as result which have either 111-526-666 or 111 526 666 or even 111/526/666?