SQLite substr function in WHERE expression

Question

Suppose I have 'employee' table with 'lname' column

I am interested in fetching all rows, where second character can be either 'e' or 'o'

What i am doing wrong, this query doesnt return anything:

SELECT * FROM employee WHERE (substr(lname,2,3)='e' OR substr(lname,2,3)='o');

Answer 1

the third parameter in substr is the length, not the end character

change to substr(lname,2,1)