MySQL - REVERSE

임재현·2021년 4월 30일
0

MySQL

목록 보기
18/52

UDEMY - The Ultimate MySQL Bootcamp: G…The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert를 보고 쓰는 글
공식문서
사실 너무 간단하다.

mysql> SELECT REVERSE('Hello World');
+------------------------+
| REVERSE('Hello World') |
+------------------------+
| dlroW olleH            |
+------------------------+
1 row in set (0.00 sec)

mysql> SELECT REVERSE(title) AS 'Reverse Title' FROM books;
+-----------------------------------------------------+
| Reverse Title                                       |
+-----------------------------------------------------+
| ekasemaN ehT                                        |
| ygolohtyM esroN                                     |
| sdoG naciremA                                       |
| seidalaM fo reterpretnI                             |
| levoN A :gniK eht rof margoloH A                    |
| elcriC ehT                                          |
| yalC & reilavaK fo serutnevdA gnizamA ehT           |
| sdiK tsuJ                                           |
| suineG gnireggatS fo kroW gnikaerbtraeH A           |
| enilaroC                                            |
| seirotS :evoL tuobA klaT eW nehW tuobA klaT eW tahW |
| seirotS detceleS :morF gnillaC m'I erehW            |
| esioN etihW                                         |
| woR yrennaC                                         |
| seirotS :noivilbO                                   |
| retsboL eht redisnoC                                |
+-----------------------------------------------------+
16 rows in set (0.00 sec)
profile
임재현입니다.

0개의 댓글