Task: SQL LIKE Condition to Check for Integer Prefix in PostgreSQL
Task: SQL LIKE Condition to Check for Integer Prefix in PostgreSQL: a task in Terminal-Lego-15k (Harbor dataset). Write a SQL query that selects all rows from a table where a text column starts with any numeric digit (0-9). This is analogous to using ILIKE 'A%' to find entries starting with the…
The task
Write a SQL query that selects all rows from a table where a text column starts with any numeric digit (0-9). This is analogous to using `ILIKE 'A%'` to find entries starting with the letter "A", but instead finding entries that start with any number.
Part of PrimeIntellect/Terminal-Lego-15k.