Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^5: database sorter script

by tachyon (Chancellor)
on Dec 07, 2004 at 00:21 UTC ( #412789=note: print w/ replies, xml ) Need Help??


in reply to Re^4: database sorter script
in thread database sorter script

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


Comment on Re^5: database sorter script

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://412789]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (10)
As of 2015-07-28 11:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (254 votes), past polls