String Functions – LPad, RPad

/*
  LPad => LPAD(String, Length, PaddedString)
  text => Field Name
*/

SELECT text AS MainText, LPAD(text, 3, '') AS TextWithPadded FROM `try`;

SELECT text AS MainText, LPAD(text, 5, '@') AS TextWithPadded FROM `try`;

SELECT text AS MainText, RPAD(text, 5, '@') AS TextWithPadded FROM `try`;