Useful mysql to remove / in a db column

torbjornzetterlund MySQL Tricks
0

Here is a handy sql statement for removing a trailing ‘/’ in the column url [callout_box] UPDATE websites SET url = LEFT(url, LENGTH(url) – 1) WHERE RIGHT(url, 1) = ‘/’ [/callout_box]

The cloud services explained

torbjornzetterlund Ways to run your web application, Web Applications, Web Development Tips Tags: , , , , , , , , ,
0

Cloud computing is the use of computing resources (hardware and software) that are delivered as a service over a network (typically the Internet). The name comes from the use of a cloud-shaped symbol as an abstraction for the complex infrastructure it contains… continue reading »