TRIM

Trim leading and trailing spaces.

TRIM removes leading and trailing spaces. LTRIM cuts from the left, RTRIM from the right.

SELECT TRIM(name) AS temiz FROM customers;

This query removes leading and trailing spaces from names.

TRIM(name) AS temiz is selected from customers.

TRIM — details

Extra spaces from data entry break search. With TRIM you clean records and get more consistent matching.

Select name trimmed from customers.

Show example solution

SELECT TRIM(name) AS temiz
FROM customers

Trim right

SELECT ____(name) FROM customers;

Show answer

SELECT RTRIM(name) FROM customers;

Next lesson: CONCAT