> At 03:35 PM 10/1/02 -0400, John W. Holmes wrote: > >You should BENCHMARK the two solutions and see which is faster. Or use > >EXPLAIN to see if there is any difference. > > I have no doubt this will be slower. Oh well, he wanted to keep the table > definitions. > > Don't forget to consider the time required for the programmer to change > all > the programs > that already have been coded.
I meant the two different queries that still solve the problem with the columns set to Y or N. Someone gave one query with a bunch of Ifs and I gave a solution with length and replace, etc. See which one of those is faster. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php