"be consistent" | |
PerlMonks |
Re^5: database sorter scriptby tachyon (Chancellor) |
on Dec 07, 2004 at 00:21 UTC ( [id://412789]=note: print w/replies, xml ) | Need Help?? |
LIKE is not inherently evil. It is a tool that has a place but does have the potential for abuse. This is the same for all tools. Nothing is fool proof, fools are simply too ingenious ;-) Anyway MySQL will also use an index for LIKE 'foo%' if there is an index available. It only table scans if you have an initial wildcard LIKE '%foo' or of course if there is no index. cheers tachyon
In Section
Seekers of Perl Wisdom
|
|