如何使用正则表达式在 sql 中搜索包含 # 标签的记录，但忽略 html 标签中的 #FFFFFF 或任何其他颜色

问：

我使用 codeigniter 作为框架。我正在设置一个过滤器选项来显示 SQL 数据库中包含哈希标签的项目，它工作得很好，但它也返回包含 html 标签的记录，例如

 style="color:#f00; color:#ff0000;  ETC

里面只有#个标签

我做了一些研究，对正则表达式的知识有限（这对我来说就像一门外语！

这工作正常。

$hashtag = "#" . $hashtag;
$this->db->like("feed_item.content", $hashtag);

我想我需要这样的东西（挣扎）。

$sq = "/^(?![\"\'].*#.*[\"\']).*$/m";
$this->db->where('LOWER(otherColumn) REGEXP', $sq);

我复制了上面的代码，并尝试修改它，但什么也没做。

我没有收到任何错误，但这是 PHP 的典型:( 当我这样做时，它没有返回任何输出：

public function get_hashtag_feed($hashtag, $userid, $page) 
   {
    $hashtag = "#" . $hashtag;
    $sq = $re = '/^(?!["\'].*#.*["\']).*$/m/g';
    //$this->db->like("feed_item.content", $hashtag);


    return $this->db
        ->select("feed_item.ID, feed_item.content, feed_item.post_as,
            feed_item.timestamp, feed_item.userid, feed_item.likes,

feed_item_polls.question as poll_question, feed_item_polls.type as poll_type,

feed_item_polls.votes as poll_votes,
            user_blog_posts.Id as blog_postid, user_blog_posts.title as blog_post_title,
            user_blog_posts.image as blog_post_image")
        ->join("users", "users.ID = feed_item.userid")
        ->join("user_images", "user_images.ID = feed_item.imageid", "left outer")
        ->join("user_albums", "user_albums.ID = user_images.albumid", "left outer")
        ->join("user_videos", "user_videos.ID = feed_item.videoid", "left outer")
        ->join("users as profile", "profile.ID = feed_item.profile_userid", "left outer")
        ->join("feed_item_polls", "feed_item_polls.ID = feed_item.pollid", "left outer")
        ->join("user_blog_posts", "user_blog_posts.ID = feed_item.blog_postid", "left outer")
        ->join("pages", "pages.ID = feed_item.pageid", "left outer")
        ->join("page_users", "page_users.pageid = feed_item.pageid AND page_users.userid = " . $userid, "LEFT OUTER")
        ->join("calendar_events", "calendar_events.ID = feed_item.eventid", "left outer")
        ->join("feed_likes", "feed_likes.postid = feed_item.ID AND feed_likes.userid = " . $userid, "LEFT OUTER")
        ->join("user_saved_posts", "user_saved_posts.postid = feed_item.ID AND user_saved_posts.userid = " . $userid, "left outer")
        ->join("feed_item_subscribers", "feed_item_subscribers.postid = feed_item.ID and feed_item_subscribers.userid = " . $userid, "LEFT OUTER")
        ->where("LOWER(otherColumn) REGEXP", $sq)
        ->order_by("feed_item.ID", "DESC")
        ->limit(10,$page)
        ->get("feed_item");