loquela Posted November 11, 2009 Share Posted November 11, 2009 Hi there, I am looking for a mysql quesry that will update any upper case characters in a a varchar column to lower case. Can anybody help please? Link to comment https://forums.phpfreaks.com/topic/181145-regex-to-update-upper-case-to-lower/ Share on other sites More sharing options...
JustLikeIcarus Posted November 11, 2009 Share Posted November 11, 2009 Why regex and not something like update table set column = lower(column) where column != lower(column) Link to comment https://forums.phpfreaks.com/topic/181145-regex-to-update-upper-case-to-lower/#findComment-955710 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.