LEFT and RIGHT

LEFT(string, count): Returns the count leftmost characters / bytes in an expression.

RIGHT(string, count): Returns the count rightmost characters / bytes in an expression.

mysql> SELECT LEFT("HELLO HARI, HOW ARE YOU", 5);
+------------------------------------+
| LEFT("HELLO HARI, HOW ARE YOU", 5) |
+------------------------------------+
| HELLO                              |
+------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT RIGHT("HELLO HARI, HOW ARE YOU", 5);
+-------------------------------------+
| RIGHT("HELLO HARI, HOW ARE YOU", 5) |
+-------------------------------------+
| E YOU                               |
+-------------------------------------+
1 row in set (0.00 sec)

Previous                                                 Next                                                 Home