convert capital letter to small letter questions

[eli03]

Greetings,

Anyone have a solution for this problem, I want to convert the url title "Artists-Materials-and-Supplies" to "artists-materials-and-supplies" . Can this be done via mysql command line or using php code ?

I have 1000+ categories, so it's hard to manualy edited the url title.

Thanks,
eli

[Boby]

Just run this simple SQL query in your phpMyAdmin or where you want:
Content visible to registered users only.
Don't forget to backup you table first!
It worked for me perfect, but you never know where an error occurs and it fails.

Boby

[eli03]

thanks, that code save me, worked perfectly. thanks boby. :D