i have a table with correct and wrong phone numbers.
wrong phone number : i need to delete the third '0' and keep the rest of the number as it is
here there's no 0 before the 7, there's nothing to do.
what would be the query in order to repair this ?
thank you in advance.