
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