mysql - update field of table -

I have a field name in the user names like birthdays, some users like birthdays =

2014/02/18

and some others like

2014-02-18

I have a date of birth Varchar should use (10)

then I want to make changes from 2014/02/18 to 2014-02-18

  select 'birthday' to 'user' Where 'Birthday' LIKE '%% %% / %% / %%' REPLACE '%%%% - %% - %%'

This code is only available for 2014/02/18 Select users with Switch to

I can change how the SQL tab at 2014-02-18?

If you want to change the data then you want an update statement:

  Update users determine birthdate (birth date, '/', '-') where date of birth '% /% /%';

You should learn to store dates in the form of dates and not as strings.

Six