LCASE()
LCASE() 함수는 문자열을 소문자로 변환한다.
⭐ LOWER() 함수는 LCASE() 함수와 동일하다.
MySQL 4.0부터 작동한다.
형식
LCASE(text)
매개변수
text
:
변환할 문자열
예제
텍스트를 소문자로 변환한다.
SELECT LCASE("SQL Tutorial is FUN!");
기본 예시
| LowercaseText |
|---|
| sql tutorial is fun! |
“CustomerName”의 텍스트를 소문자로 변환한다.
SELECT LCASE(CustomerName) AS LowercaseCustomerName FROM Customers;
기본 예시
| LowercaseCustomerName |
|---|
| alfreds futterkiste |
| ana trujillo emparedados y helados |
| antonio moreno taquería |
| around the horn |
| berglunds snabbköp |
| blauer see delikatessen |
| blondel père et fils |
| bólido comidas preparadas |
| bon app’ |
| bottom-dollar marketse |
| b’s beverages |
| cactus comidas para llevar |
| centro comercial moctezuma |
| chop-suey chinese |
| comércio mineiro |
| consolidated holdings |
| drachenblut delikatessend |
| du monde entier |
| eastern connection |
| ernst handel |
| familia arquibaldo |
| fissa fabrica inter. salchichas s.a. |
| folies gourmandes |
| folk och fä hb |
| frankenversand |
| france restauration |
| franchi s.p.a. |
| furia bacalhau e frutos do mar |
| galería del gastrónomo |
| godos cocina típica |
| gourmet lanchonetes |
| great lakes food market |
| grosella-restaurante |
| hanari carnes |
| hilarión-abastos |
| hungry coyote import store |
| hungry owl all-night grocers |
| island trading |
| königlich essen |
| la corne d’abondance |
| la maison d’asie |
| laughing bacchus wine cellars |
| lazy k kountry store |
| lehmanns marktstand |
| let’s stop n shop |
| lila-supermercado |
| lino-delicateses |
| lonesome pine restaurant |
| magazzini alimentari riuniti |
| maison dewey |
| mère paillarde |
| morgenstern gesundkost |
| north/south |
| océano atlántico ltda. |
| old world delicatessen |
| ottilies käseladen |
| paris spécialités |
| pericles comidas clásicas |
| piccolo und mehr |
| princesa isabel vinhoss |
| que delícia |
| queen cozinha |
| quick-stop |
| rancho grande |
| rattlesnake canyon grocery |
| reggiani caseifici |
| ricardo adocicados |
| richter supermarkt |
| romero y tomillo |
| santé gourmet |
| save-a-lot markets |
| seven seas imports |
| simons bistro |
| spécialités du monde |
| split rail beer & ale |
| suprêmes délices |
| the big cheese |
| the cracker box |
| toms spezialitäten |
| tortuga restaurante |
| tradição hipermercados |
| trail’s head gourmet provisioners |
| vaffeljernet |
| victuailles en stock |
| vins et alcools chevalier |
| die wandernde kuh |
| wartian herkku |
| wellington importadora |
| white clover markets |
| wilman kala |
| wolski |
참고
W3C School - MySQL LCASE() Function
W3C School - SQL Tutorial
공부 목적 블로그