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 vote211 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
18 votes147 views2 answers
How to get all the tables displayed in oracle
SQL
2 votes223 views1 answer
Postgresql transaction
SQL
0 vote166 views1 answer
Sqlite3 now
SQL
0 vote183 views1 answer
New rails app with mysql
SQL
0 vote176 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
0 vote165 views1 answer
How to get initials in sql
SQL
0 vote186 views1 answer
Connect by query in oracle
SQL
1 vote189 views1 answer
Set statiscis on in ssms
SQL
0 vote175 views1 answer
Oracle drop default value
SQL