MySQL String Function

MySQL string functions manipulate the character string data effectively. The following table indicates each of the functions with a brief description:

FunctionsDescription
CONCAT_WS()MySQL CONCAT_WS() function returns a string by concatenating arguments using separator.
CONCAT()The CONCAT() function returns a string by concatenating all the arguments.
CHARACTER_LENGTH()The CHARACTER_LENGTH() function returns the size of the specified string.
ELT()The ELT() function returns the Nth element from the list of string.
EXPORT_SET()The EXPORT_SET() function the returns string for each bit set.
FIELD()The FIELD() function returns the index of string.
FIND_IN_SET()The FIND_IN_SET() function returns the value of the string which is given in the first position in the argument.
FORMAT()The FORMAT() function formats the number X to round of D decimal place.
FROM_BASE64()The FROM_BASE64() function encodes the given string to binary format.
HEX()The HEX() function returns the specified number or string in a hexadecimal string.
INSERT()In INSERT() function, a string str is passed with a position 'pos' which tells at which position the character is to be placed, and 'len' length is the length of the character to be placed.
INSTR()The INSTR() function returns the 1st occurrence of substring substr in string str.
LCASE()The LCASE() function returns 1st occurrence of substring substr in string str.
LEFT()The LEFT() function returns left side 'len' characters from the given string 'str'.
LENGTH()The LENGTH() function returns the length of the specified string which is measured in bytes.
LIKE()The LIKE() function returns either 1 or 0 and is used for checking pattern matching.
LOAD_FILE()The LOAD_FILE() function returns the content of the file.
LOCATE()The LOCATE() function returns the first occurrence of given 'substr' in the given string.
LOWER()The LOWER() function returns the given string in lower case.
LPAD()The LPAD() function returns string 'str' which is left-padded to the given length.
LTRIM()The LTRIM() function returns string by removing leading space.
MAKE_SET()The MAKE_SET() function returns values from the set for the given bit.
MID()The MID() function extracts a substring from a string and returns a string with given length and position.
OCTET_LENGTH()The OCTET_LENGTH() function returns length of given string.
OCT()The OCT() function returns length of given string.
ORD()The ORD() function returns the code for the leftmost character if that character is a multi-byte.
POSITION()The POSITION() function returns the position of the given substring in a string.
QUOTE()The QUOTE() function returns the string which is passed in a single quote.
REPEAT()The REPEAT() function repeats a string for a specified number of times.
REPLACE()The REPLACE() function replaces all the occurrences of a substring within a string.
REVERSE()The REVERSE() function reverses a string supplied as an argument.
RIGHT()The RIGHT() function extracts a specified number of characters from the right side of a string.
RPAD()The MYSQL RPAD() function pads the specified strings from the right.
RTRIM()The MYSQL RTRIM() function removes the trailing spaces from the specified string.
SOUNDEX()The MYSQL SOUNDEX() function returns the soundex string for the specified string.

Example 1

Output:

mysql> SELECT SOUNDEX('javatpoint');
+-----------------------+
| SOUNDEX('javatpoint') |
+-----------------------+
| W6262                 | 
+-----------------------+
1 row in set (0.00 sec)

Example 2

Output:

mysql> SELECT ORD('mysql'); 
+-------------------+
| ORD('mysql') |
+-------------------+
|               109 | 
+-------------------+
1 row in set (0.00 sec)

Example 3

Output:

mysql> SELECT REPEAT('*+*',15); 
+-----------------------------------------------+
| REPEAT('*+*',15)                              |
+-----------------------------------------------+
| *+**+**+**+**+**+**+**+**+**+**+**+**+**+**+* | 
+-----------------------------------------------+
1 row in set (0.03 sec)
Next TopicMySQL String




Latest Courses