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 vote337 views1 answer
Update row in sqlite python
SQL
5 votes358 views4 answers
Select random rows sql
SQL
0 vote334 views1 answer
Acual month sql
SQL
23 votes344 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote380 views1 answer
Min mysql
SQL
0 vote337 views1 answer
Xampp mysql version
SQL
1 vote364 views1 answer
Postgresql define pk sequence next number
SQL
0 vote363 views1 answer
Compare subqueries oracle
SQL
0 vote361 views2 answers
Search stored procedures by name
SQL
0 vote372 views1 answer
Sql server information_schema temp tables
SQL