Normalize text for search
SQL
Hard
4 views
Problem Description
Create a query that removes spaces and lowercases product names for matching a user input.
Sample Test Case
Output:
Normalized column
Constraints
Use REPLACE + LOWER
Official Solution
SELECT product_id, LOWER(REPLACE(name, ' ', '')) AS normalized_name FROM Products;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!