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…