Was wondering if someone had a solution. I have a database of image names that a PHP app points to. Some of the image names are upper case. Can anyone suggest the syntax of an "Update" statement that will change all Upper Case letters to lower??
UPDATE MyTable SET MyField = LOWER(MyField)
___/ / __/ / ____/ Ed Leafe
Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]