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? Quote 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) Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.