SELECT Name FROM Employees WHERE Name LIKE '[A-E]%'
SELECT Name FROM Employees WHERE Name REGEXP '^[A-E].*$'
BETWEEN
SELECT name FROM test WHERE name BETWEEN 'a' AND 'e'
name
test
SELECT * FROM Employee WHERE Name LIKE '[A-E]%';
SELECT * FROM myTable WHERE SUBSTRING([employeeName], 1, 1) >= 'A' AND SUBSTRING([employeeName], 1, 1) <= 'E'
SELECT Name FROM Employees WHERE Name LIKE '[A-E][F-J][K-O][P-T][U-Z]%'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)