I have a big database in which the website
column values are malformed:
http://.www.123.com.au, http://.www.exampleurl.com
I want to correct these urls by removing this extra character .
as:
http://www.123.com.au, http://www.exampleurl.com
I get these values by passing following select statement:
SELECT *
FROM `tbl_business`
WHERE `website` LIKE 'http://.%';