MySQL FullText Search seems doesn't work

Question

SELECT * FROM `pt_acf` WHERE `palavra` 
LIKE "%orai%"

Showing records # 0-29 (62 total, Query took 0.0608 seconds)

SELECT * FROM `pt_acf` WHERE MATCH(`palavra`)
AGAINST("orai")

Showing records # 0-17 (18 total, Query took 0.0008 seconds)

Why in LIKE search found 62 records and in FULLTEXT only 18? The time is great but it didn't found all the records.

score 0 · Answer 1 · edited May 23 '17 at 11:49

0

This post might help you out with difference between fulltext search and like:

edited May 23 '17 at 11:49

Community

answered Mar 26 '13 at 01:04

ssn771

1 Answers1