UCASE()
UCASE() 함수는 문자열을 대문자로 변환한다.
⭐ 이 함수는 UPPER() 함수와 동일하다.
MySQL 4.0부터 작동한다.
형식
UCASE(text)
매개변수
text
:
변환할 문자열
예제
텍스트를 대문자로 변환해보자.
SELECT UCASE("SQL Tutorial is FUN!");
기본 예시
UppercaseText |
---|
SQL TUTORIAL IS FUN! |
“CustomerName”의 텍스트를 대문자로 변환해보자.
SELECT UCASE(CustomerName) AS UppercaseCustomerName FROM Customers;
기본 예시
UppercaseCustomerName |
---|
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 UCASE() Function
W3C School - SQL Tutorial