• 131
• 255
• 14

Useful mysql to remove / in a db column

by bernt & torsten

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) = '/'