How to remove hyphens using MySQL UPDATE?

Question

Possible Duplicate:
How can I use mySQL replace() to replace strings in multiple records?
MySQL search to ignore hyphens

What is the best way to remove hyphens from a field using mysql UPDATE without php?

field: 211-555-1212 > 2115551212

Very similar to http://stackoverflow.com/questions/4271186/how-can-i-use-mysql-replace-to-replace-strings-in-multiple-records - May have your answer. — Chalise, Oct 23 '12 at 16:10

score 43 · Accepted Answer · answered Oct 23 '12 at 16:10

43

You can use the REPLACE() function, for UPDATE

UPDATE yourtable
SET field = replace(field, '-', '')

For SELECT:

SELECT replace(field, '-', '') field
FROM yourtable

answered Oct 23 '12 at 16:10

Taryn

1 Answers1