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

24 votes219 views2 answers
Alter table delete column
SQL
0 vote222 views1 answer
How to connect postgresql database with java
SQL
0 vote250 views1 answer
Example database query
SQL
0 vote200 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote262 views1 answer
Dual in db2
SQL
1 vote210 views1 answer
Reutrn string after character sql
SQL
15 votes239 views5 answers
Show tables in oracle
SQL
12 votes229 views10 answers
Google
SQL
3 votes254 views5 answers
No module named 'MySQLdb'
SQL
1 vote248 views1 answer
Dropping a constraint in ms sql
SQL