How do I find rows where country starts with the letter F in SQL?
SELECT * FROM data
WHERE country LIKE 'F%';
Run this query in QueryLocal →
`country LIKE 'F%'` matches any value starting with "F", 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).