skip to Main Content

MySQL fulltext search over multiple columns

I've created a table with an full-text index over 2 columns: CREATE TABLE players ( id int NOT NULL, first_name varchar(25) NOT NULL, last_name varchar(25) NOT NULL, team_id int NOT NULL, PRIMARY KEY (id), FULLTEXT INDEX full_text_pname (first_name, last_name), CONSTRAINT…

VIEW QUESTION
Back To Top
Search