Tech Leadership Advice & Resources

Books, worksheets, templates, frameworks and other useful resources for Chief Technology Officers (CTOs), VPs of Engineering & Technology Directors

Snippets

Convert to sentence case in MySQL

Isabel Nyo 20232023

UPDATE `tablename` 
SET `fieldname` =  CONCAT(UCASE(SUBSTRING(`fieldname`,1,1)),'', 

LCASE(SUBSTRING(`fieldname`,2,LENGTH(`fieldname`)))) 
WHERE `id` = 1