CODEWITHSUNDEEP
mysqlsearchselectsql-likematch-against
Mohammad Saberi
Mohammad Saberi

Reputation: 13166

How to search a word in MySQL table? MATCH AGAINST or LIKE?

I have a table for some companies that may have many branches in different countries. These countries are inserted in countries field.
Now, I have to make a searching system that allows users to find companies that have any branch in a specific country.
My question is: Which one do I have to use ? MATCH AGAINST or LIKE ? The query must search all records to find complete matched items.

Upvotes: 3

Views: 2135

Answers (3)

JDGuide
JDGuide

Reputation: 6525

You should use LIKE . Because as @Omesh mentioned MATCH AGAINST clause is used for Full Text Search.. And Full Text Search need entire column for search.

Upvotes: 0

Nir Alfasi
Nir Alfasi

Reputation: 53525

I would change the implementation: having a field that contains multiple values is a bad idea, for example, it's difficult to maintain - how will you implement remove a country from a company ?.

I believe that a better approach would be to have a separate table companies_countries which will have two columns: company_id and country_id, and could have multiple lines per company.

Upvotes: 3

Omesh
Omesh

Reputation: 29061

MATCH AGAINST clause is used in Full Text Search.

for this you need to create a full text index on search column countries.

full text index search is much faster than LIKE '%country%' serach.

Upvotes: 5

Related Questions