LOGIN
Monday, May 20, 2024
Top Posts
SUBSCRIBE NEWSLETTERS
Home » MySQL String LPAD() Function
MySQL String FunctionMysql Tutorial

MySQL String LPAD() Function

by Online Tutorials Library

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

Example 1

Output:

MySQL String LPAD() Function

Example 2

Output:

MySQL String LPAD() Function

Next TopicMySQL String

You may also like

MySQL String LENGTH() Function

MySQL String MID() Function

MySQL String OCTET_LENGTH() Function

MySQL String POSITION() Function

MySQL String LEFT() Function

MySQL String LOWER() Function