Display the enames who have more than two ' l ' or exactly three ' l ' in their enames from table emp?

Question

👍

Answer 1

select enames from emp where enames like 'l%'
selext enames from emp where enames like 'lll'
Something like this. please lookup the correct syntax. Just wrote down what was in my mind.

https://www.tutorialspoint.com/sql/sql-like-clause.htm

Answer 2

Just adding a point after @Sneeze, you can use '%' to include any match. e.g.

SELECT enames FROM emp WHERE enames LIKE '%ll%' OR enames LIKE '%lll%';

I hope I get it right, was it lower 'L' or upper 'i'?, either way I guess you get the point.

Hth, cmiiw