mysql>mysql> SELECT LEFT('cats and dogs', 4);+--------------------------+| LEFT('cats and dogs', 4) |+--------------------------+| cats |+--------------------------+1 row in set (0.00 sec)mysql>