Removes leading and trailing spaces (or specified characters).
Syntax
TRIM([{LEADING|TRAILING|BOTH} c FROM] str)Example
Enter values below to update the example in real time.
customers→name→UPDATE customers SET name = TRIM(name)
WHERE name != TRIM(name);