Databases Querying Relational Databases Set Operations Set Operations

why doesnt this query work in bringing back distinct fruits and veggies starting with letters A-K?

SELECT Name FROM Fruit WHERE Name LIKE "[A-K]%" UNION SELECT Name FROM Vegetable WHERE Name LIKE "[A-K]%";

1 Answer

Sean T. Unwin
Sean T. Unwin
28,651 Points

It seems the DB doesn't like RegExp operations.

The technique to use is found near the 4:00 mark in the Union Operations Lesson. This is to use the less than operator ("<") and we want anything that begins with a letter less than 'L'.