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 vote173 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote176 views1 answer
Manage Database in MySQL
SQL
1 vote180 views1 answer
Search for replace in mysql
SQL
0 vote161 views1 answer
Json_remove mysql
SQL
0 vote215 views1 answer
Sql check if field is not null
SQL
0 vote174 views1 answer
Difference between db.query and db.execute
SQL
5 votes176 views2 answers
Sql constraint check value in list
SQL
2 votes182 views2 answers
Mysql count rows returned
SQL
0 vote159 views1 answer
Increment id in mysql
SQL
0 vote199 views1 answer
Replace divide by zero error with 0 in sql
SQL