LPAD()
LPAD() 함수는 문자열을 특정 길이까지 다른 문자열로 왼쪽부터 채운다.
MySQL 4.0부터 작동한다.
형식
LPAD(string, length, lpad_string)
매개변수
string
:
기존 문자열. 기존 문자열의 길이가 length 매개 변수보다 클 경우 이 함수는 문자열에서 오버플로 문자를 제거한다.
length
:
왼쪽 패드를 넣은 후 문자열의 길이
lpad_string
:
왼쪽부터 length 매개 변수만큼 길이를 만들기위해 채울 문자열
예제
총 길이가 20이 되도록 문자열을 “ABC”로 왼쪽부터 채운다.
SELECT LPAD("SQL Tutorial", 20, "ABC");
기본 예시
| LPAD(“SQL Tutorial”, 20, “ABC”) |
|---|
| ABCABCABSQL Tutorial |
총 길이가 30이 되도록 “CustomerName”의 텍스트를 “ABC”로 왼쪽부터 채운다.
SELECT LPAD(CustomerName, 30, "ABC") AS LeftPadCustomerName FROM Customers;
기본 예시
| LeftPadCustomerName |
|---|
| ABCABCABCABAlfreds Futterkiste |
| Ana Trujillo Emparedados y hel |
| ABCABCAAntonio Moreno Taquería |
| ABCABCABCABCABCAround the Horn |
| ABCABCABCABCBerglunds snabbköp |
| ABCABCABlauer See Delikatessen |
| ABCABCABCABlondel père et fils |
| ABCABBólido Comidas preparadas |
| ABCABCABCABCABCABCABCABon app’ |
| ABCABCABBottom-Dollar Marketse |
| ABCABCABCABCABCABB’s Beverages |
| ABCACactus Comidas para llevar |
| ABCACentro comercial Moctezuma |
| ABCABCABCABCAChop-suey Chinese |
| ABCABCABCABCABComércio Mineiro |
| ABCABCABCConsolidated Holdings |
| ABCABDrachenblut Delikatessend |
| ABCABCABCABCABCDu monde entier |
| ABCABCABCABCEastern Connection |
| ABCABCABCABCABCABCErnst Handel |
| ABCABCABCABCFamilia Arquibaldo |
| FISSA Fabrica Inter. Salchicha |
| ABCABCABCABCAFolies gourmandes |
| ABCABCABCABCABCAFolk och fä HB |
| ABCABCABCABCABCAFrankenversand |
| ABCABCABCABFrance restauration |
| ABCABCABCABCABCAFranchi S.p.A. |
| Furia Bacalhau e Frutos do Mar |
| ABCABCABGalería del gastrónomo |
| ABCABCABCABGodos Cocina Típica |
| ABCABCABCABGourmet Lanchonetes |
| ABCABCAGreat Lakes Food Market |
| ABCABCABCAGROSELLA-Restaurante |
| ABCABCABCABCABCABHanari Carnes |
| ABCABCABCABCABHILARIÓN-Abastos |
| ABCAHungry Coyote Import Store |
| ABHungry Owl All-Night Grocers |
| ABCABCABCABCABCAIsland Trading |
| ABCABCABCABCABCKöniglich Essen |
| ABCABCABCALa corne d’abondance |
| ABCABCABCABCABLa maison d’Asie |
| ALaughing Bacchus Wine Cellars |
| ABCABCABCALazy K Kountry Store |
| ABCABCABCABLehmanns Marktstand |
| ABCABCABCABCALet’s Stop N Shop |
| ABCABCABCABCALILA-Supermercado |
| ABCABCABCABCABLINO-Delicateses |
| ABCABCLonesome Pine Restaurant |
| ABMagazzini Alimentari Riuniti |
| ABCABCABCABCABCABCMaison Dewey |
| ABCABCABCABCABCAMère Paillarde |
| ABCABCABMorgenstern Gesundkost |
| ABCABCABCABCABCABCANorth/South |
| ABCABCABOcéano Atlántico Ltda. |
| ABCABCABOld World Delicatessen |
| ABCABCABCABCOttilies Käseladen |
| ABCABCABCABCAParis spécialités |
| ABCABPericles Comidas clásicas |
| ABCABCABCABCABPiccolo und mehr |
| ABCABCAPrincesa Isabel Vinhoss |
| ABCABCABCABCABCABCAQue Delícia |
| ABCABCABCABCABCABQueen Cozinha |
| ABCABCABCABCABCABCABQUICK-Stop |
| ABCABCABCABCABCABRancho grande |
| ABCARattlesnake Canyon Grocery |
| ABCABCABCABCReggiani Caseifici |
| ABCABCABCABCRicardo Adocicados |
| ABCABCABCABCRichter Supermarkt |
| ABCABCABCABCABRomero y tomillo |
| ABCABCABCABCABCABSanté Gourmet |
| ABCABCABCABCSave-a-lot Markets |
| ABCABCABCABCSeven Seas Imports |
| ABCABCABCABCABCABSimons bistro |
| ABCABCABCASpécialités du monde |
| ABCABSplit Rail Beer & Ale |
| ABCABCABCABCABSuprêmes délices |
| ABCABCABCABCABCAThe Big Cheese |
| ABCABCABCABCABCThe Cracker Box |
| ABCABCABCABCToms Spezialitäten |
| ABCABCABCABTortuga Restaurante |
| ABCABCABTradição Hipermercados |
| Trail’s Head Gourmet Provision |
| ABCABCABCABCABCABCVaffeljernet |
| ABCABCABCAVictuailles en stock |
| ABCABVins et alcools Chevalier |
| ABCABCABCABCADie Wandernde Kuh |
| ABCABCABCABCABCAWartian Herkku |
| ABCABCABWellington Importadora |
| ABCABCABCAWhite Clover Markets |
| ABCABCABCABCABCABCAWilman Kala |
| ABCABCABCABCABCABCABCABCWolski |
참고
W3C School - MySQL LPAD() Function
W3C School - SQL Tutorial
공부 목적 블로그