REVERSE()
REVERSE() 함수는 문자열을 반전시키고 결과를 반환한다.
MySQL 4.0부터 작동한다.
형식
REVERSE(string)
매개변수
string
:
반전할 문자열
예제
문자열을 반전시켜보자.
SELECT REVERSE("SQL Tutorial");
기본 예시
| REVERSE(“SQL Tutorial”) |
|---|
| lairotuT LQS |
CustomerName의 텍스트를 반전시켜보자.
SELECT REVERSE(CustomerName) FROM Customers;
기본 예시
| REVERSE(CustomerName) |
|---|
| etsikrettuF sderflA |
| sodaleh y sodaderapmE ollijurT anA |
| aíreuqaT oneroM oinotnA |
| nroH eht dnuorA |
| pökbbans sdnulgreB |
| nessetakileD eeS reualB |
| slif te erèp lednolB |
| sadaraperp sadimoC odilóB |
| ‘ppa noB |
| estekraM ralloD-mottoB |
| segareveB s’B |
| ravell arap sadimoC sutcaC |
| amuzetcoM laicremoc ortneC |
| esenihC yeus-pohC |
| orieniM oicrémoC |
| sgnidloH detadilosnoC |
| dnessetakileD tulbnehcarD |
| reitne ednom uD |
| noitcennoC nretsaE |
| lednaH tsnrE |
| odlabiuqrA ailimaF |
| .A.S sahcihclaS .retnI acirbaF ASSIF |
| sednamruog seiloF |
| BH äf hco kloF |
| dnasrevneknarF |
| noitaruatser ecnarF |
| .A.p.S ihcnarF |
| raM od soturF e uahlacaB airuF |
| omonórtsag led aírelaG |
| acipíT anicoC sodoG |
| setenohcnaL temruoG |
| tekraM dooF sekaL taerG |
| etnaruatseR-ALLESORG |
| senraC iranaH |
| sotsabA-NÓIRALIH |
| erotS tropmI etoyoC yrgnuH |
| srecorG thgiN-llA lwO yrgnuH |
| gnidarT dnalsI |
| nessE hcilginöK |
| ecnadnoba’d enroc aL |
| eisA’d nosiam aL |
| sralleC eniW suhccaB gnihguaL |
| erotS yrtnuoK K yzaL |
| dnatstkraM snnamheL |
| pohS N potS s’teL |
| odacremrepuS-ALIL |
| sesetacileD-ONIL |
| tnaruatseR eniP emosenoL |
| itinuiR iratnemilA inizzagaM |
| yeweD nosiaM |
| edralliaP erèM |
| tsokdnuseG nretsnegroM |
| htuoS/htroN |
| .adtL ocitnáltA onaécO |
| nessetacileD dlroW dlO |
| nedalesäK seilittO |
| sétilaicéps siraP |
| sacisálc sadimoC selcireP |
| rhem dnu olocciP |
| ssohniV lebasI asecnirP |
| aicíleD euQ |
| ahnizoC neeuQ |
| potS-KCIUQ |
| ednarg ohcnaR |
| yrecorG noynaC ekanselttaR |
| icifiesaC inaiggeR |
| sodacicodA odraciR |
| tkramrepuS rethciR |
| ollimot y oremoR |
| temruoG étnaS |
| stekraM tol-a-evaS |
| stropmI saeS neveS |
| ortsib snomiS |
| ednom ud sétilaicépS |
| elA ;pma& reeB liaR tilpS |
| seciléd semêrpuS |
| eseehC giB ehT |
| xoB rekcarC ehT |
| netätilaizepS smoT |
| etnaruatseR agutroT |
| sodacremrepiH oãçidarT |
| srenoisivorP temruoG daeH s’liarT |
| tenrejleffaV |
| kcots ne selliautciV |
| reilavehC sloocla te sniV |
| huK ednrednaW eiD |
| ukkreH naitraW |
| arodatropmI notgnilleW |
| stekraM revolC etihW |
| alaK namliW |
| iksloW |
참고
W3C School - MySQL REVERSE() Function
W3C School - SQL Tutorial
공부 목적 블로그