Removes leading and trailing spaces (or specified characters).
Syntax
TRIM([{BOTH|LEADING|TRAILING} remstr FROM] str)Example
Enter values below to update the example in real time.
customers→address→-- 입력값 앞뒤 공백 제거 후 저장
UPDATE customers
SET address = TRIM(address)
WHERE TRIM(address) <> address;