MySQL ORD() Function17 Mar 2025 | 1 min read ORD(str) is a Sring function of MySQL This method returns code for the given string. 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 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 REPEAT() Function REPEAT(str,count) is a Sring function of MySQL. This method returns the string reputation counter times. Syntax select repeat(str, count); Example 1 select repeat('javatpoint ', 4); Output: Example 2 select repeat('mysql ', 2); 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 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 SPACE() Function The space() is a String function of MySQL. This function returns the given number (n) of blank spaces. Syntax select space(n); Parameters: N: number of spaces to be returned. Returns This function returns a string with a specified number of spaces. Example 1 select space(5); Output: Example 2 select space(10); Output: TopicMySQL String ...
1 min read
MySQL LOAD_FILE() Function LOAD_FILE(file_name) is a Sring function of MySQL. This method returns content of file. If file does not exist or it cannot be read then it returns NULL. Syntax LOAD_FILE(file_name); Example 1 Update table1 set img= LOAD_FILE('D:\image_file.jpg'); Output: TopicMySQL String ...
1 min read
MSQL CONCAT_WS() Function Concat_ws() is a Sring function of MySQL. This method has a separator and returns a string by concatenating arguments using separator. It can have more than one argument. Syntax select concat_ws(separator,str1,str2,...); Example 1 select concat_ws(',','Id','Password','Name'); Output: Example 2 select concat_ws(',','Name','Class','School'); 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 LTRIM() Function LTRIM(str) is a Sring function of MySQL. This method returns string by removing leading space. Syntax select ltrim(str); Example 1 Select ltrim(' Javatpoint'); Output: Example 2 Select ltrim(' 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