MySQL MAKE_SET() Function17 Mar 2025 | 1 min read MAKE_SET(bits,str1,str2,...) is a Sring function of MySQL. This method returns values from set for the given bit. SyntaxExample 1Output:  Example 2Output:  Example 3Output:  Example 4Output:  Next TopicMySQL String |
MySQL CONCAT() Function Concat() is a Sring function of MySQL This method returns a string by concatenating all the arguments. It can have more than one argument. Syntax select concat('arg1','arg2','arg3',....); Example 1 select concat('java','t','point'); Output: Example 2 select concat('m','y','s','q','l'); Output: TopicMySQL String ...
1 min read
MySQL RTRIM() Function The Rtrim() is a String function of MySQL. This method removes the extra space if present in the tail of the string. Syntax select rtrim(str); Parameters Str: string for which extra space is to be removed from the tail. Example 1 Select rtrim('javatpoint '); Output: Example 2 Select rtrim('mysql ...
1 min read
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 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 LOWER() Function LOWER(str) is a Sring function of MySQL. This method returns the given string in lower case. Syntax select lower(str); Example 1 Select lower('JAVATPOINT'); Output: Example 2 Select lower('MYSQL'); Output: TopicMySQL String ...
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 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 ELT() Function Elt() function is a Sring function of MySQL. This method Nth element from the list of string. Syntax select elt(N,str1,str2,str3,...) Example 1 select elt(3,'this','is','javatpoint','website') Output: Example 2 select elt(4,'my','sql','string','function') Output: TopicMySQL String ...
1 min read
MySQL FIELD() Function Field(str,str1,str2,str3,....) is a Sring function of MySQL. This method returns the index of string. Syntax select field(str,str1,str2,str3,...) Example 1 Selct field('a','b','c','d','a'); Output: Example 2 Selct field(4,1,2,3,5,4,6); Output: Example 3 Selct field(12,1,2,3,4,6); Output: TopicMySQL String ...
1 min read
MySQL LEFT() Function LEFT(str,len) is a Sring function of MySQL. This method returns left side 'len' characters from the given string 'str'. Syntax select LEFT(str,len) Example 1 select left('Javatpoint',4); Output: Example 2 select left('MY SQL STRING FUNCTION',6); 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