Name
UCASE()
Synopsis
UCASE(string
)
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 | +-----------+----------------------+
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.