[GLLUG] MySQL Help

[Mel Wade]

I've got a problem with a MySQL database and need some help.

 

The field 'birthday' is varchar and a recent import of users placed birthdates in the following format.

1970-12-31

 

There are supposed to be 

12-31-1970

 

I need to be able to fix this, but not change the ones that are correct.

 

I could so this in switch easily in ColdFusion and MSSQL (my home turf), but I'm not sure about PHP and MySQL.

 

Can anyone help me with a quick fix for this?

 

Mel Wade, IT Director

Michigan Conference of Seventh-day Adventists

517.316.1580

517.316.1582 Fax

"Change is Inevitable. Growth is Optional."

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.egr.msu.edu/mailman/public/linux-user/attachments/20060330/6f307801/attachment.html