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

2 votes183 views1 answer
Add new column not null sql server
SQL
0 vote183 views1 answer
Oracle concat datetime
SQL
3 votes187 views1 answer
Sql insert inserted id
SQL
0 vote173 views1 answer
How to check default value of column in sql server
SQL
0 vote160 views1 answer
Insert or update cassandra
SQL
0 vote209 views1 answer
SQL Where-Klausel
SQL
0 vote173 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
0 vote198 views1 answer
Oracle current date minus 1 day
SQL
1 vote189 views1 answer
Postgresql round double precision
SQL
0 vote166 views1 answer
Inspecting a column unique/distinct values in SQL
SQL