Question

How can we use the output of LTRIM() and RTRIM() functions to update MySQL table?

Answer 1

• If you want to remove only leading or trailing spaces, you can use other string functions: LTRIM and RTRIM . The following statement uses the LTRIM function to remove the leading spaces of a string.