MySQL CHARACTER_LENGTH() function

CHARACTER_LENGTH()

MySQL CHARACTER_LENGTH() returns the length of a given string. The length is measured in characters. The CHARACTER_LENGTH() is the synonym of CHAR_LENGTH().

Syntax:

 
CHARACTER_LENGTH (str)

Argument:

Syntax Diagram:

MySQL Version: 8.0

Example : MySQL CHARACTER_LENGTH() function

The following MySQL statement counts the length of the string specified as an argument.

Code:

SELECT CHARACTER_LENGTH('test string');

Output:

mysql> SELECT CHARACTER_LENGTH('test string');
+---------------------------------+
| CHARACTER_LENGTH('test string') |
+---------------------------------+
|                              11 | 
+---------------------------------+
1 row in set (0.00 sec)

Example of MySQL character_length() function where clause

The following MySQL statement counts only those of the publisher's names (from column pub_name of the publisher table) which are more than 20 characters long.

Code:

SELECT pub_name,CHARACTER_LENGTH(pub_name)
AS 'character length'
FROM publisher
WHERE CHARACTER_LENGTH(pub_name)>20;

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,CHARACTER_LENGTH(pub_name)
    -> AS 'character length'
    -> FROM publisher
    -> WHERE CHARACTER_LENGTH(pub_name)>20;
+------------------------------+------------------+
| pub_name                     | character length |
+------------------------------+------------------+
| New Harrold Publication      |               23 | 
| Summer Night Publication     |               24 | 
| Pieterson Grp. of Publishers |               28 | 
+------------------------------+------------------+
3 rows in set (0.00 sec)

Video Presentation:

All String Functions (Slides presentation)

PREV : CHAR
NEXT : CONCAT_WS