MySQL HEX(str), HEX(N) Function17 Mar 2025 | 1 min read Hex() is a Sring function of MySQL. This method return in hexadecimal string of given number or String. SyntaxExample 1Output:  Example 2Output:  Example 3Output:  Next TopicMySQL String |
MySQL SUBSTRING_INDEX() Function The substring_index() is a String function of MySQL. This function returns a substring from the given string(str) before the counts come of the delimiter. Syntax select substring_index(str, delim, count); Parameter: str: main string delim: string to be searched count: number of times to search delim Returns: This function returns the substring of...
1 min read
MySQL OCT() Function Oct(n) is a Sring function of MySQL. This method returns octal value of given number (n). Syntax select oct(n); Example 1 select oct(10); Output: Example 2 select oct(123); Output: TopicMySQL String ...
1 min read
MySQL INSTR() Function INSTR(str,substr) is a Sring function of MySQL. This method return 1st occurrence of substring substr in string str. Syntax select instr(str,substr); Example 1 Select instr('Javanpoint',5,1,'t'); Output: Example 2 Select instr('MySql-Function',6,1,'String'); Output: TopicMySQL String ...
1 min read
MySQL EXPORT_SET() Function Export_set() is a Sring function of MySQL. This method returns string for each bit set. Syntax select export_set(bits,on,off[,separator[,number_of_bits]]); Example 1 select export_set(5, 'Yes','No',',',4); Output: Example 2 select export_set(5, 'hello','bye',',',4); Output: TopicMySQL String ...
1 min read
MySQL OCTET_LENGTH() Function OCTET_LENGTH(str) is a Sring function of MySQL. This method returns length of given string. Syntax select octet_length(str); Example 1 select octet_length('Javatpoint'); Output: Example 2 select octet_length('mysql); 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 MID() Function MID(str,pos,len) is a Sring function of MySQL. This method returns string of given length and position. Syntax select mid(str, pos, len); Example 1 Select mid('mysql', 3, 4); Output: Example 2 Select mid('Javatpoint', 6, 6); 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 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 LOCATE() Function LOCATE(substr,str) is a Sring function of MySQL. This method returns the first occurrence of given substr in the given string, Syntax select locate(substr, str); Example 1 select locate('point', 'javatpoint'); Output: Example 2 select locate('sql, 'mysql'); 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