[MySQL] LPAD()

MySQL 문자열 함수와 연산자

 

LPAD()

   -

 

LPAD(str, len, padstr)

의 형태

Returns the string str, left-padded with the string padstr to a length of len characters. If str is longer than len, the return value is shortened to len characters.

 

mysql> SELECT LPAD('hi', 4, '??') ;
+---------------------+
| LPAD('hi', 4, '??') |
+---------------------+
| ??hi                |
+---------------------+
1 row in set (0.00 sec)

mysql> SELECT LPAD('hi', 1, '??') ;
+---------------------+
| LPAD('hi', 1, '??') |
+---------------------+
| h                   |
+---------------------+
1 row in set (0.00 sec)