Re: MySQL: 11 Mil Rows = Slow Performance!

Derrick Shields - <1182537069.716376.120720@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> :

So here is my question.  What is the difference between LIKE 'value'
and LIKE '%VALUE%'? When you add the percentage signs, I understand
the percentage signs are wild cards, but if you're using LIKE without
wildcard percentage signs, is that technically the same as saying
"="?

Yes, but when searching with a wildcard at the beginning wont use the
created indexes.
That's all.

.

Relevant Pages

  • Re: Why does Mahut even have to qualify?
    ... That he wasnt given a wildcard and that he may not be in the biggest ... Because the wild cards were awarded before they knew he'd make such a ...
    (rec.sport.tennis)
  • Re: vlookup retunrning a match, when not a match...
    ... for any single character ... an asterisk or question mark--not as wild cards. ... So if you're using an =vlookup() for instance, ... I think it's because of a wildcard search that it's calling it a match? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: specifying multiple "not like" criteria
    ... as john said the use of like is for wild cards but there is no reason ... you cannot use it without wildcard as you seem to realise. ...
    (microsoft.public.access.queries)
  • Re: GET and POST dropping wildcard characters in DB query
    ... > backend DB (which is Ingres 2.0) through a web interface. ... The one I am struggling with is searching our parts database ... > because I want to allow wildcard searches. ...
    (comp.lang.javascript)
  • Re: Need help with Countif function
    ... Without the wildcard ... I got too many hits, for example, just searching for ... "Biff" wrote: ... I tried countif statements with no success. ...
    (microsoft.public.excel.worksheet.functions)