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 vote376 views1 answer
Neo4j command to run script file
SQL
0 vote355 views1 answer
Sql where part of string match
SQL
0 vote347 views2 answers
Update query with between in mysql
SQL
0 vote354 views1 answer
Select row with latest date mysql
SQL
0 vote340 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
1 vote351 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote342 views1 answer
Use between operator in mysql
SQL
2 votes402 views1 answer
Query to check cpu utilization in oracle database
SQL
8 votes350 views2 answers
Grant all privileges database postgres to user
SQL
6 votes381 views3 answers
How to delete table sqlite
SQL