MySQL LOWER() function

LOWER() function

MySQL LOWER() converts all the characters in a string to lowercase characters.

This function is useful in -

• Lowercase conversion: This converts all uppercase characters in a string to lowercase.
• Data normalization: The LOWER() function can be used to normalize strings within your data.
• Case-insensitive comparisons: Lower() is often used with comparison operations to perform case-insensitive comparisons.

Syntax:

LOWER(str)

Argument:

Syntax Diagram:

MySQL Version: 8.0

Example: MySQL LOWER() function

The following MySQL statement returns the given string after converting all of its characters in lowercase.

Code:

SELECT LOWER('MYTESTSTRING');

Output:

mysql> SELECT LOWER('MYTESTSTRING'); 
+-----------------------+
| LOWER('MYTESTSTRING') |
+-----------------------+
| myteststring          | 
+-----------------------+
1 row in set (0.01 sec)

Example of LOWER() on column of a table

The following MySQL statement returns those rows from the publisher table whose publishers does not belong to the USA. The column pub_name and after converting the pub_name column in lowercase is displayed in the output.

Code:

SELECT pub_name,LOWER(pub_name) 
FROM publisher 
WHERE country<>'USA';

Sample table: publisher

+--------+------------------------------+-----------+-----------+----------------+--------------+------------+
| pub_id | pub_name                     | pub_city  | country   | country_office | no_of_branch | estd       |
+--------+------------------------------+-----------+-----------+----------------+--------------+------------+
| P001   | Jex Max Publication          | New York  | USA       | New York       |           15 | 1969-12-25 |
| P002   | BPP Publication              | Mumbai    | India     | New Delhi      |           10 | 1985-10-01 |
| P003   | New Harrold Publication      | Adelaide  | Australia | Sydney         |            6 | 1975-09-05 |
| P004   | Ultra Press Inc.             | London    | UK        | London         |            8 | 1948-07-10 |
| P005   | Mountain Publication         | Houstan   | USA       | Sun Diego      |           25 | 1975-01-01 |
| P006   | Summer Night Publication     | New York  | USA       | Atlanta        |           10 | 1990-12-10 |
| P007   | Pieterson Grp. of Publishers | Cambridge | UK        | London         |            6 | 1950-07-15 |
| P008   | Novel Publisher Ltd.         | New Delhi | India     | Bangalore      |           10 | 2000-01-01 |
+--------+------------------------------+-----------+-----------+----------------+--------------+------------+

Output:

mysql> SELECT pub_name,LOWER(pub_name) 
    -> FROM publisher 
    -> WHERE country<>'USA';
+------------------------------+------------------------------+
| pub_name                     | LOWER(pub_name)              |
+------------------------------+------------------------------+
| BPP Publication              | bpp publication              | 
| New Harrold Publication      | new harrold publication      | 
| Ultra Press Inc.             | ultra press inc.             | 
| Pieterson Grp. of Publishers | pieterson grp. of publishers | 
| Novel Publisher Ltd.         | novel publisher ltd.         | 
+------------------------------+------------------------------+
5 rows in set (0.00 sec)

Video Presentation:

All String Functions (Slides presentation)

PREV : LOCATE
NEXT : LPAD