Is it possible to query count post contains hashtag(#) where same hashtag(#) more than 1 in column.
Example :
tb_post
post_id | post
1 | #enjoy #go_green
2 | I like this #enjoy
3 | What about me? #enjoy #enjoy
4 | We have to back to nature #forlive #go_green #go_green
Is it possible to count #enjoy that should be 4 and #go_green 3?
Here is my query
SELECT SUBSTR( post, LOCATE( '#', post ) ) hashtag
FROM tb_post
WHERE post LIKE '%#enjoy%'
LIMIT 0 , 30
When I execute that, it's only show 3. It should be 4.