CodesJava

Easy learning with example program codes

LTRIM() FUNCTION in MySQL

LTRIM() FUNCTION
The MySQL LTRIM function is used to remove all space characters from the left-hand side of a string. The various versions of MySQL supports the LTRIM function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23.

Syntax:

LTRIM( string )

Parameters:
string: It is used to specify the string to modify.

Example 1:

mysql> SELECT LTRIM ( '  HELLO' );

Output:

 'HELLO’

Explanation:
All thee space characters are removed from the left-hand side of the string.

Example 2:

mysql> SELECT LTRIM ( '  HELLO  ' );

Output:

 'HELLO  ’

Explanation:
All thee space characters are removed from the left-hand side of the string.

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status