[AndreT]

Quote:

Originally Posted by wups Yeah. Btw i doubt about the speed incrase without the quotes. I even benchmarked Select WHERE ID and Select WHERE NAME. Didn't make any difference. So the only advantage i can think off is a smaller packet sent to the server.

A small speed difference would make sense - there's less for the machine to go over, less to process. Meaning a smaller packet size as you said, this means less to process by the MySQL server receiving the query!

Also there's a mistake in this query which I didn't mange spotting before:
SELECT `Name` FROM `players` WHERE `something='%d'
The `something` field ending quotation isn't ended properly, so it'll either have to be:
SELECT `Name` FROM `players` WHERE `something`='%d' (which is useless and I wouldn't suggest it)
Or...
SELECT Name FROM players WHERE something=%d (which is more like it!)