CONTAINS: Word search, needs a word index on the field and correctly defined word break ( for example does not work out-of-the-box with UTF-8 databases ).
MATCHES: Searches for a pattern within a string, you can use an asteriks as a wild card - never indexed regardless whether there is an index on the field or not and therefore will always end up scanning the whole table.
BEGINS: Searches for string beginning with the given pattern - indexed when the field is indexed.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.