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 vote308 views1 answer
Mysql select row with min date
SQL
0 vote332 views1 answer
How to select a row in sql
SQL
0 vote404 views1 answer
Mysql get longest string in column
SQL
1 vote351 views1 answer
Primary key with prefix sql
SQL
0 vote353 views1 answer
Psql store procedure-return multiple table values
SQL
4 votes324 views1 answer
Add constraint fk
SQL
1 vote309 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote312 views2 answers
Sql drop view if exists
SQL
1 vote308 views1 answer
How to print longest name in sql
SQL
0 vote341 views1 answer
Basic structure of sql expression having clause
SQL