SQLite String start with first 6 letters in alphabet table-CodePudding

Home > Net > SQLite String start with first 6 letters in alphabet table

SQLite String start with first 6 letters in alphabet table

Time：10-12

I need to select the name strings that the first character to be on of A to F or a to f, here is my select clause, but I got noting returned.

SELECT name FROM pet WHERE lower(name) LIKE '[A-Fa-f]%';

CodePudding user response：

You could use the GLOB operator here:

SELECT name
FROM pet
WHERE name GLOB '[A-Fa-f]*';