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

4 votes258 views3 answers
Mysql update with join
SQL
0 vote322 views1 answer
Oracle convert int to date
SQL
0 vote268 views1 answer
Sql tablo hangi sp de
SQL
17 votes249 views5 answers
Order by sql
SQL
1 vote268 views1 answer
How to see logical reads in sql server
SQL
0 vote260 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote210 views1 answer
Online sql compiler
SQL
0 vote259 views1 answer
Login failed for user sql server
SQL
0 vote302 views1 answer
Sparql list all graphs
SQL
0 vote255 views1 answer
Regex mongoose
SQL