Weather used in php or any other scripting language… sometimes we have the need to query a database in order to fetch or manipulate certain data.
One of the most common request, widely written and used is
SELECT * FROM MyTable WHERE ID='ValueX' and NAME='ValueY'; now, ID and NAME are just columns… so nothing special
However.. how could someone optimize that line of code? Fact is, lots of coders out there, do not realize how unoptimize this line could be and the different problems it could generate.