Here is a handy sql statement for removing a trailing ‘/’ in the column url
UPDATE websites SET url = LEFT(url, LENGTH(url) - 1) WHERE RIGHT(url, 1) = '/'
Here is a handy sql statement for removing a trailing ‘/’ in the column url
UPDATE websites SET url = LEFT(url, LENGTH(url) - 1) WHERE RIGHT(url, 1) = '/'
by
Leave a Reply