MySQL MID() Function17 Mar 2025 | 1 min read MID(str,pos,len) is a Sring function of MySQL. This method returns string of given length and position. SyntaxExample 1Output:  Example 2Output:  Next TopicMySQL String |
MySQL CHARACTER_LENGTH() Function Character_Length (str) function is a Sring function of MySQL. This method is same as char_length() function which returns size of given string. Syntax select character_length(str); Example 1 select character_length('javatpoint'); Output: Example 2 select character_length('mysql'); Output: TopicMySQL String ...
1 min read
MySQL HEX(str), HEX(N) Function Hex() is a Sring function of MySQL. This method return in hexadecimal string of given number or String. Syntax select hex(S or N) Example 1 Select hex('a'); Output: Example 2 Select hex('b'); Output: Example 3 Select hex('c'); Output: TopicMySQL String ...
1 min read
MySQL RPAD() Function The RPAD() is a String function of MySQL. This method returns the given string which is right-padded with the string padstr to the given length (len). Syntax select rpad(str, len, padstr) Parameters str: string to be right padded rpad: length of the padding padstr: string to be padded Returns This function returns...
1 min read
MySQL LCASE() Function LCASE(str) is a Sring function of MySQL. This method returns string in lower case. Syntax select lcase('JAVATPOINT'); Example 1 select lcase('JAVATPOINT'); Output: Example 2 select lcase('MY SQL STRING FUNCTION'); Output: TopicMySQL String ...
1 min read
MySQL REVERSE(str) Function The REVERSE() is a String function of MySQL. This method returns the given string in reverse order. Syntax select reverse(str); Parameter str: string to be reversed Returns This function returns a string with the characters in reverse order. Example 1 Select reverse('javatpoint'); Output: Example 2 Select reverse('mysql); Output: TopicMySQL String ...
1 min read
MySQL MAKE_SET() Function MAKE_SET(bits,str1,str2,...) is a Sring function of MySQL. This method returns values from set for the given bit. Syntax select make_set(bits, str1, str2,...); Example 1 Select make_set(1, 'apple','mango','grapes'); Output: Example 2 Select make_set(1|3, 'apple','mango','grapes'); Output: Example 3 Select make_set(1|4, 'apple','mango','grapes'); Output: Example 4 Select make_set(4, 'apple','mango','grapes'); Output: TopicMySQL String ...
1 min read
MySQL LPAD() Function LPAD(str,len,padstr) is a Sring function of MySQL. This method returns string 'str' which is left padded to the given length. Syntax select lpad(str, len, padstr) Example 1 Select lpad('java', 2, '**'); Output: Example 2 Select lpad('mysql', 3, '**'); Output: TopicMySQL String ...
1 min read
MySQL UCASE() Function The ucase() is a String function of MySQL. This function returns the string in upper case. Syntax select ucase(str) Parameter: str: string to be convert Example 1 Select ucase('javatpoint'); Output: Example 2 Select ucase('mysql'); Output: TopicMySQL String ...
1 min read
MySQL FROM_BASE64() Function From_base64(str) is a Sring function of MySQL. This method encode the given string to binary formate. Syntax select from_base64(str) ; Example 1 Select from_base64('java') as 'Input'; Output: Example 2 Select from_base64('mysql') as 'output'; Output: TopicMySQL String ...
1 min read
MySQL UNHEX() Function The unhex() is a String function of MySQL. This function converts the hexadecimal value into a string. Syntax select unhex(str); Parameter: str: hexadecimal value. Example 1 Select unhex('6a61766174706f696e74'); Output: Example 2 Select unhex('4d7953716c537472696e6746756e6374696f6e'); Output: TopicMySQL String ...
1 min read
We request you to subscribe our newsletter for upcoming updates.
We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks
G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India
Python
Java
JavaScript
SQL
C
C++
HTML
CSS
React
Node.js
Spring Boot
C#
PHP
MySQL
MongoDB
AI
ML
DSA
DBMS
OS
Aptitude
Reasoning