SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table_name (
  column_name VARCHAR(100) 
);
✓
INSERT INTO table_name VALUES ('hello');
✓
SELECT column_name, (LENGTH(column_name) - LENGTH(REPLACE(column_name, 'l', ''))) / LENGTH('l') cnt FROM table_name


column_name
cnt


hello
2


SELECT column_name, (LENGTH(column_name) - LENGTH(REPLACE(column_name, 'll', ''))) / LENGTH('ll') cnt FROM table_name


column_name
cnt


hello
1