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 vote145 views1 answer
Sql server get date of previous sunday
SQL
0 vote178 views1 answer
"Hello User Name"
SQL
0 vote175 views1 answer
Database db connection string format
SQL
0 vote173 views1 answer
Mysqli last row
SQL
0 vote104 views1 answer
How to get last client id sql
SQL
19 votes238 views5 answers
Mysql between date range
SQL
0 vote175 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
1 vote161 views1 answer
Create new table from old table
SQL
0 vote142 views1 answer
Set column width in sqlplus
SQL
3 votes154 views1 answer
Oracle drop user
SQL