[thelist] Regular Expression help (MySQL)

[Rick den Haan]

Mattias Thorslund wrote:
> If you clean your data to a consistent format, you will be
> able to run the LIKE comparison easier.

This is what we ended up doing. We didn't have permissions to modify the
column type, or to add a new column to the table. We appear to have only
SELECT, INSERT, UPDATE and DELETE permissions.

I ended up modifying all scripts that write phone numbers to the database,
to make sure new entries or updates are always numeric, I then wrote a
simplistic search/replace script to UPDATE the records.

I should have been able to think of that myself :)

Thanks,

Rick.