conditional update records mysql query
- by Shakti Singh
Hi,
Is there any single msql query which can update customer DOB?
I want to update the DOB of those customers which have DOB greater than current date.
example:- if a customer have dob 2034 update it to 1934 , if have 2068 updated with 1968.
There was a bug in my system if you enter date less than 1970 it was storing it as 2070.
The bug is…