MySQL - Command to change to lower case

freeflow · 08-18-2008, 02:53 PM

How can I change all all entries in a specific column to lower case?

Thanks.

sdsinc · 08-18-2008, 03:56 PM

Code:

UPDATE [table] SET [field]=LOWER([field])

08-18-2008, 02:53 PM	#1 (permalink)
freeflow NamePros Member Join Date: Dec 2006 Posts: 136 12.00 NP$ (Donate)	MySQL - Command to change to lower case How can I change all all entries in a specific column to lower case? Thanks.

08-18-2008, 03:56 PM	#2 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 6,285 1,095.94 NP$ (Donate)	Code: UPDATE [table] SET [field]=LOWER([field]) __________________ Buy now - MassDeveloper.com $500

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)