I have a table with a day_phone field. Sometimes the numbers are stored
as 123-456-7890 sometimes there 1234567890. I want users to be able to
search the database, so they can search for 1234567890 and the row will
be returned weather it has -'s in it or not.
select day_phone from table where day_phone LIKE '[user_input]%'
I could do it in the PHP side, but that will be much slower. Ive looked
into REGEXP, but that only returns 1 or 0.
I just need to return the numbers from a field, without changing the
data in the database. Thanks!...