>_ QueryLocal All recipes
SQL recipe

How do I find rows where country starts with the letter U in SQL?

SELECT * FROM data
WHERE country LIKE 'U%';
Run this query in QueryLocal →

`country LIKE 'U%'` matches any value starting with "U", since `%` stands for any run of characters (including zero). This is the same LIKE-with-wildcard pattern used to search names or categories, just applied to country.

A table named data with columns: order_id (integer), customer (text), country (text), category (text), quantity (integer), unit_price (real), order_date (text, YYYY-MM-DD).