Open ywarnier opened 3 years ago
There is a skill design floor but searching for floor doesn't return this skill.
design floor
floor
The search should at least be of type SELECT name FROM skills WHERE name LIKE '%$search%' rather than SELECT name FROM skills WHERE name LIKE '$search%';
SELECT name FROM skills WHERE name LIKE '%$search%'
SELECT name FROM skills WHERE name LIKE '$search%';
The best way to do it would be to add a fulltext index to the table and use MATCH() AGAINST () instead of LIKE. See https://dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html
MATCH() AGAINST ()
LIKE
There is a skill
design floorbut searching forfloordoesn't return this skill.The search should at least be of type
SELECT name FROM skills WHERE name LIKE '%$search%'rather thanSELECT name FROM skills WHERE name LIKE '$search%';The best way to do it would be to add a fulltext index to the table and use
MATCH() AGAINST ()instead ofLIKE. See https://dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html