SQL Query for hashtag links

Vote count:

0

I have a (Wordpress and Buddypress) website under development. The site encourages use of hashtags in the Buddypress status updates.

I need to be able to show what's "trending" on the site, and list the most mentioned hashtags. These status updates with the hashtags are stored in a SQL database table, and could be any length. Is there a way I can search this database table for any hashtags, then list by most popular? Basically I need something like

SELECT # FROM status_updates WHERE (the status) INCLUDES (anything beginning with #) ORDER BY (most popular)

asked 1 min ago

user3470229

1