MySQL LCASE() Function17 Mar 2025 | 1 min read LCASE(str) is a Sring function of MySQL. This method returns string in lower case. SyntaxExample 1Output:  Example 2Output:  Next TopicMySQL String |
MySQL Trim() Function The trim() is a String function of MySQL. This function removes the blank spaces from the head and tail of the given string. Syntax TRIM( [ LEADING | TRAILING | BOTH ] [ trim_character FROM ] string ) Parameter: str: string to be trimmed leading: it removes blank spaces...
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
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 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 UPPER() Function The upper() is a String function of MySQL. This function returns the string in upper case. Syntax select upper(str) Parameter: Str: string to be converted Returns: This function returns the string in upper case. Example 1 Select upper('javatpoint'); Output: Example 2 Select upper('mysql'); Output: TopicMySQL String ...
1 min read
MySQL POSITION() Function POSITION(substr IN str) is a Sring function of MySQL. This method returns position of the given sub string in string. Syntax select position(substr in str) Example 1 select position('point' in 'Javatpoint'); Output: Example 2 select position('string' in 'mysql_string_function'); Output: TopicMySQL String ...
1 min read
Function MySQL string functions manipulate the character string data effectively. The following table indicates each of the functions with a brief description: Functions Description 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...
3 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 SUBSTR() Function The substr() is a String function of MySQL. This function returns the substring from the given string. Syntax select substr(Str, pos); Select substr(Str from pos); Select substr(Str, pos, len); Select substr(Str from pos for len); Parameter: Str: Main string Len: length for substring Pos: position the start the substring from the given string. Example...
1 min read
MySQL SOUNDEX() Function The Soundex() is a String function of MySQL. This method returns a Soundex string. Two strings which sound almost same should have identical soundex strings. Syntax select soundex(str); Example 1 Select soundex('javatpoint'); Output: Example 2 Select soundex('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