Name

LOWER()

Synopsis

LOWER(str)

This is the inverse of UPPER. Returns the string str with all the characters changed to lowercase. This code returns the string “queen elizabeth ii”:

SELECT LOWER('Queen Elizabeth II');

Get Learning PHP, MySQL, JavaScript, and CSS, 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.