Update ALL CAPS values to Capitalize

Question

Is it possible to select values in all caps and update those values to capitalize with the same query?

I am able to select them like this:

SELECT *
FROM t1
WHERE name REGEXP BINARY '^[A-Z]+$';

Can you explain the distinction between "all caps" and "to capitalize"? Do you mean "uppercase" to "titlecase"? — Chris J, Jan 09 '19 at 19:37
Do you want "VERY IMPORTANT" to be "Very Important" or "Very important"? — Schwern, Jan 09 '19 at 19:37
@santa Oh lord, MySQL implicit case-insensitivity strikes again. — Schwern, Jan 09 '19 at 19:41
@Schwern ...not really much of a MySQL... not sure what it means. — santa, Jan 09 '19 at 19:47

score 0 · Answer 1 · answered Jan 09 '19 at 19:39

0

update t1
set name = ...
where name = regexp binary '^[A-Z]+$';

Where that ... is any number of solutions from this answer.

Do this in a transaction in case there's a mistake.

answered Jan 09 '19 at 19:39

Schwern

1 Answers1