Search "BBQ Bill"

SELECT `main_table`.*, (0 + FORMAT(MATCH (title, meta_keywords, meta_description, identifier, content) AGAINST ("'BBQ Bill'"), 4)) AS `search_rate` FROM `magefan_blog_post` AS `main_table` WHERE (`main_table`.`is_active` = '1') AND (`main_table`.`publish_time` <= '2021-04-21 01:05:59') AND ((`title` LIKE '%BBQ Bill%') OR (`short_content` LIKE '%BBQ Bill%') OR (`content` LIKE '%BBQ Bill%')) Search "BBQ Bill"