String Functions – Left, Right, Mid

/*
  Left => LEFT(String, Length)
  text => Field Name
*/

SELECT LEFT(text, 3) FROM `try`;

/*
  Mid => MID(String, Position, Length)
  text => Field Name
*/

SELECT MID(text, 2, 3) FROM `try`;

/*
  Right => RIGHT(String, Length)
  text => Field Name
*/

SELECT RIGHT(text, 3) FROM `try`;