String Functions – Trim, Ltrim, Rtrim

/*
  Trim => TRIM(Methods[Leading | Trailing | Both] [Remove String] From [String])
  text => Field Name
*/

SELECT text, TRIM(text) AS textWithoutSpace FROM `try`;

SELECT text, TRIM(LEADING FROM text) AS textWithoutSpace FROM `try`;

SELECT text, TRIM(TRAILING FROM text) AS textWithoutSpace FROM `try`;

SELECT text, TRIM(BOTH FROM text) AS textWithoutSpace FROM `try`;

SELECT
  text, TRIM(BOTH FROM text) AS textWithoutSpace,
  CHAR_LENGTH(TRIM(BOTM FROM text)) AS BothTrim
FROM
  `try`;

SELECT
  text, TRIM(BOTH FROM text) AS textWithoutSpace,
  CHAR_LENGTH(TRIM(BOTH FROM text)) AS BothTrim,
CHAR_LENGTH(text) AS textLengthWithoutTrim,
FROM
  `try`;

SELECT
  text, TRIM(LEADING FROM text) AS textWithoutLeadingSpace,
  CHAR_LENGTH(text) AS textLengthWithoutTrim,
  CHAR_LENGTH(TRIM(LEADING FROM text)) AS LeadingTrim,
FROM
  `try`;

SELECT text, TRIM(LEADING '@' FROM text) AS textWithTrim FROM `try`;

SELECT text, TRIM(TRAILING '@' FROM text) AS textWithTrim FROM `try`;

SELECT text, TRIM(BOTH '@' FROM text) AS textWithTrim FROM `try`;

SELECT text, LTRIM(text) AS textWithTrim FROM `try`;

SELECT text, RTRIM(text) AS textWithTrim FROM `try`;