MySQL OCT() Function17 Mar 2025 | 1 min read Oct(n) is a Sring function of MySQL. This method returns octal value of given number (n). SyntaxExample 1Output:  Example 2Output:  Next TopicMySQL String |
MySQL LENGTH() Function LENGTH(str) is a Sring function of MySQL. This method returns length of the given string ?str? which is measured in bytes. Syntax select LENGTH(str); Example 1 select length('Javatpoint'); Output: Example 2 select length('MY SQL STRING FUNCTION'); 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 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 INSERT() Function INSERT(str,pos,len,newstr) is a Sring function of MySQL. In this method, 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 i.e string...
1 min read
MySQL QUOTE() Function Quote(str) is a Sring function of MySQL. This method returns the string which is passed in single quote. Syntax select quote(str); Example 1 select quote('javatpoint is a website'); Output: Example 2 select quote('mysql String function'); 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 STRCMP() Function The strcmp() is a String function of MySQL. This function compares the given two strings. This function returns 0 if both the strings are same, -1 if the first string is smaller than second else it returns 1. Syntax select strcmp(str1, str2); Parameters: Str1 and str2: two strings...
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 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 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
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