I've a table which contains customer phone numbers, this numbers are filled with different formats, for eg some times, 91 803 22 22 22 and some time 91802323232 and sometime 803242525.
The question is when I do a search using mysql for eg select * from customer where phone LIKE