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);

Create fulltext index mysql

CREATE FULLTEXT INDEX IF NOT EXISTS idx_col1_col2 ON
    tableName(col1, col2);
    
SELECT
    *
FROM
    tableName
WHERE
    MATCH(col1, col2) AGAINST("search words");

Similar codes

0 vote267 views1 answer
What is mysql_pconnect
SQL
0 vote268 views1 answer
Inner joint
SQL
1 vote275 views1 answer
Float precision in psql
SQL
3 votes255 views4 answers
Show sql server database
SQL
0 vote282 views1 answer
Sql date d'aujourd'hui
SQL
0 vote303 views1 answer
Postgresql stored procedure update table values
SQL
29 votes274 views6 answers
Delete all rows from table mysql
SQL
0 vote296 views1 answer
Mysql listing get a particu particular user firsdt
SQL
3 votes307 views2 answers
How to force truncate a table in mysql
SQL
0 vote260 views1 answer
Oracle execute immediate quotes
SQL