how to count string occurrence in column

Hi All


How can i count how many time a string 'hello' appear in a column.

for example.

select *, count_num_of_string(column, 'hello') from table;

Cheer