How to remove hyphens using MySQL UPDATE? [duplicate]

mysql sql

You can use the REPLACE() function, for UPDATE

UPDATE yourtableSET field = replace(field, '-', '')

For SELECT:

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

CodeHunter