All I'm asking is Standard SQL, I don't blame you to use MySQL. Pierre.
On Wed, 2009-08-26 at 10:34 -0400, Nancy Wichmann wrote: > Pierre Rineau wrote: > > If you test a integer field, use no quotes, if you test a varchar field, > > use quotes, that's it. Your DBMS will be smarter than you (except MySQL, > > but for kitten sake, do standard SQL, it will be easier for PostgreSQL > > user like me to port your code if needed). > > Then why, Pierre, is the quoted version faster, by far? At least in MySql. > > Please stop disparaging MySql. The vast majority of sites use it, so it > can't be all bad. > > Nancy E. Wichmann, PMP > > Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, > Jr. >
