数据库中的Hashtags

I'm curious to know how I could select anything in my database with a #tag and show it in any page I like. As I'm wanting to show all tags made by other users and then will also extend on it of the, "you may also like..."

I've tried:

$text = preg_replace('#[^a-z0-9_]#i', '','');

 $results = mysqli_query($mysqli, "SELECT * FROM blogdata_comments WHERE comment_content LIKE '%#$text%' ORDER BY comment_id DESC");

echo"<a style='color:#0000FF;' href='hash.php?tag=$text'>$text</a>";