What is the advantage of using the LIKE clause in mysql

Vote count:

0

I want to creat a dictionary web site, and i want to know which one will be better for search in my dictionary:

SELECT col FROM table WHERE col='anything'

OR

SELECT col FROM table WHERE col LIKE '%anything%'

which one have a more speed and prformance? tnx

asked 11 secs ago

Sajad

3

What is the advantage of using the LIKE clause in mysql