duminică, iulie 07, 2013

How to title case strings in MySQL

How to Title case words in MySQL:

UPDATE person SET lastname= CONCAT( UPPER( SUBSTRING( lastname, 1, 1 ) ) , LOWER( SUBSTRING( lastname FROM 2 ) ) );

How to Title case word delimited with '-' in MySQL:

update person set lastname= CONCAT( UPPER(SUBSTRING(lastname, 1, 1)) , LOWER(SUBSTRING(lastname FROM 2 FOR (LOCATE( '-', lastname ) -1 ) ) ), UPPER(SUBSTRING(lastname FROM (LOCATE( '-', lastname ) +1 ) FOR 1 ) ) , LOWER(SUBSTRING(lastname FROM (LOCATE( '-', lastname ) +2 ) )) ) WHERE lastname LIKE '%-%'

Membri

Comentarii