What is Full Text Search vs LIKE
In general, there is a tradeoff between “precision” and “recall”. High precision means that fewer irrelevant results are presented (no false positives), while high recall means that fewer relevant results are missing (no false negatives). Using the LIKE operator gives you 100% precision with no concessions for recall. A full text search facility gives you … Read more