ma.tt
Cool Query of the Day
To remove trailing slashes from URIs: UPDATE `blogs` SET blog_uri = LEFT(blog_uri, (LENGTH(blog_uri) – 1) ) WHERE RIGHT( blog_uri, 1 ) = ‘/’; Rows affected: 328,561 in 92 seconds.
