I believe you can do it with something like:
SELECT COUNT(*) FROM table_name
WHERE where column_name LIKE '%substring%';
Please note, I haven't tested this. It should return a single row containing a number which is the number of times the substring appears in the column. The % signs are necessary.