Why should you care?

UPI and phone search often strip spaces and +91 prefixes before matching — SQL helps batch exports.

See it live — copy this example

Run in MySQL Workbench or the mysql CLI.

SELECT customer_id,
       TRIM(full_name) AS name_clean,
       UPPER(city) AS city_upper,
       CONCAT(full_name, ' (', city, ')') AS label
FROM customers
WHERE full_name LIKE '%sharma%';

What happened?

• TRIM removes accidental spaces.
• UPPER standardizes city for grouping.
• CONCAT builds CSV-friendly label.
• LIKE does pattern match on name.

Practice next

1. Insert name with leading spaces.
2. Run TRIM demo.
3. Try REPLACE(full_name,' ',' ') for double spaces.
4. Use REGEXP for stricter phone format.
5. ORDER BY LENGTH(full_name) DESC for longest names.

Remember

Clean and format text in SELECT. LIKE for pattern search; consider FULLTEXT later. CONCAT builds derived columns.

DataFlow duplicate name cleanup

Ops exports TRIM(full_name) list to merge typo accounts before merge tool runs.

Outcome: Support queue shrinks after dedupe.