create fulltext index mysql
-- examble to create fulltext index on posts table on blog
CREATE FULLTEXT INDEX IF NOT EXISTS idx_title_body ON
posts(title, body);
SELECT
*
FROM
posts
WHERE
MATCH(title, body) AGAINST("search words" IN BOOLEAN MODE);