Table of Contents for

MySQL in a Nutshell, 2nd Edition

This function converts a given string to all uppercase letters. It’s an alias of UPPER(). Here is an example:

SELECT course_id AS 'Course ID',
UCASE(course_name) AS Course
FROM courses LIMIT 3;

+-----------+----------------------+
| Course ID | Course               |
+-----------+----------------------+
|      1245 | CREATIVE WRITING     |
|      1255 | PROFESSIONAL WRITING |
|      1244 | AMERICAN LITERATURE  |
+-----------+----------------------+