Informatics Practices

To remove the leading and trailing space from data values in a column of MySQL Table, we use

  1. Left()
  2. Right()
  3. Trim()
  4. Ltrim()

SQL Queries

1 Like

Answer

Trim()

Reason — The TRIM() function removes leading and trailing spaces from a given string. It performs combined functions of LTRIM() and RTRIM().

Answered By

3 Likes


Related Questions