Torbjorn Zetterlund

Sat 31 2013
Image

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

Share:
Sun 2024-09-29
Image

Why It’s Important to Exercise When You’re Over 60

Many of us find ourselves in a pickle as the years pile up. Once reliable sidekicks, our...

Sat 2024-09-14
Image

A Poem: The Last Time

You never know when it will be,
The last time you ski down slopes of snow,

Sat 2024-08-31
Image

A Poem: Time Millionaire

When the morning wakes, still and clear,  
No more alarms, no more rush....