[MYSQL] column indexing - fourslickz/notes GitHub Wiki

SHOW INDEXING

SHOW INDEXES FROM table_name;

---

Add Btree Index

create index table_name_column_name on table_name(column_name);

---

Create FULLTEXT index using CREATE INDEX statement

CREATE FULLTEXT INDEX index_name ON table_name(idx_column_name,...)

---

Add Fulltext Index

ALTER TABLE your_table_name ADD FULLTEXT INDEX index_name (your_text_column);

---

Remove Index

ALTER TABLE your_table_name DROP INDEX index_name;

---

Perform Full-Text Searches

SELECT * FROM your_table_name WHERE MATCH(your_text_column) AGAINST ('search_query');