CHAR_LENGTH() Function in MySQL

Last Updated : 21 Jun, 2022

CHAR_LENGTH() function in MySQL is used to find the length of a given string (in characters). It counts the number of characters and ignore whether the character(s) are single-byte or multi-byte.

Syntax :

CHAR_LENGTH(str)

Parameter : This method accepts one parameter as mentioned above and described below :

str : A string whose length to be calculated.

Returns : It returns the length of a given string.

Example-1 : CHAR_LENGTH() function to find the length for a String.

SELECT CHAR_LENGTH("geeksforgeeks") AS LengthOfString

Output :

LengthOfString
13

Example-2 : CHAR_LENGTH() function to find the length for a String.

SELECT CHAR_LENGTH("SQL Tutorial in geeksforgeeks") AS LengthOfString

Output :

LengthOfString
29

Example-3 : CHAR_LENGTH() function to find the length for every String in a column of a Table.

Table – Student_Details :

Student_Roll	Student_Name	Total_Marks
1	Amit	450
2	Aniket	470
3	Sanjana	432
4	Nirmal	475

SELECT CHAR_LENGTH(Student_Name) AS LengthOfName FROM Student_Details;

Output :

LengthOfName
4
6
7
6

LEFT() Function in MySQL

jana_sayantan

Improve

Article Tags :

Similar Reads

CHARACTER_LENGTH() Function in MySQL

CHARACTER_LENGTH() : This function in MySQL helps to find the length of given string. The length is measured in form of characters. Moreover, CHARACTER_LENGTH() is also the synonym of CHAR_LENGTH() function. Syntax : CHARACTER_LENGTH(string) Parameter : The function accepts only one parameter as fol

1 min read

BIT_LENGTH() Function in MySQL

BIT_LENGTH() function in MySQL is used to find the length of a given string in bits. The input string can be a character string or number string. Syntax : BIT_LENGTH(str) Parameter : Required. str : A string whose bits length to be calculated. Returns : It returns the length of a given string in bit

1 min read

MySQL LENGTH() Function

MySQL LENGTH() function returns the length of a string in bytes. SyntaxThe MySQL LENGTH function syntax is: LENGTH(string) ParametersThe LENGTH function accepts only one parameter. string: A specified string whose length is to be counted.MySQL LENGTH() Function ExamplesLet's look at examples of the

1 min read

LEFT() Function in MySQL

The LEFT() function in MySQL is used to extract a specified number of characters from the left side of a given string. It uses its second argument to decide, how many characters it should return. Syntax: LEFT (str, len)Parameter: This function accepts two parameters as mentioned above and described

1 min read

LN() Function in MySQL

LN() function : It is the function in MySQL is used to calculate the natural logarithm of a specific number with base e . The number must be greater than 0, otherwise it will return NULL. Syntax : LN(X) Parameter : LN() function accepts one parameter as mentioned above in the syntax and described be

2 min read

OCTET_LENGTH() Function in MySQL

In this article, we are going to cover the OCTET_LENGTH function. And will see syntax and example of OCTET_LENGTH function. Let's discuss one by one. OCTET_LENGTH function in MySQL is used to returns the number of characters in a given string. Syntax : OCTET_LENGTH( str ) Parameter : This function a

1 min read

LEAST() Function in MySQL

The LEAST() function in MySQL is a versatile tool that returns the smallest (minimum) value from a list of expressions. It can be used with numbers, strings, or even columns of data to find the minimum value according to their data type. In this article, We will learn about LEAST() Function in MySQL

4 min read

MONTH() function in MySQL

MySQL MONTH() function returns the month from the given date. It returns a month value between 1 and 12 or returns 0 when the month part of the date is 0. It's a useful SQL function for date manipulation and analysis, particularly when dealing with reports or queries that require month-based groupin

3 min read

LOG() Function in MySQL

LOG() function in MySQL is used to calculate the natural logarithm of a specific number. The number must be >0 Otherwise it will return NULL. Syntax : LOG(X) Parameter : This method accepts one parameter as mentioned above and described below : X : A number whose logarithm value we want to calcul

3 min read

INET_ATON() function in MySQL

INET_ATON() : This function in MySQL takes the dotted-quad representation of an IPv4 address as a string and returns the numeric value of the given IP address in form of an integer. If the input address is not a valid IPv4 address this function returns NULL. The return address is calculated by the f

2 min read