I have a MySQL table where two columns are text but they contain text data. Most date entries are formatted dd/mm/yyyy and I would like those changed to yy/mm/dd The important thing is that not all dates in these columns are formatted dd/mm/yyyy. Some columns are blank, some contain various other pieces of text. I would like you to iterate through the table, only converting date values from the two columns if dd/mm/yyyy is found. The table is about 6100 rows long. The attached example is for you to see the table itself, and an example of some of the data. The date columns are `in_service_from` and `out_of_service`. The columns will remain as text, you will just be converting the format of the dates in text. I will upload the real data in the same format once the winning bidder is chosen. Thanks :-)
## Deliverables
1) a .sql file, formatted like the one attached, containing the original data with modified dates as per requirements
## Platform
MySQL