View Single Post
  #6 (permalink)  
Old December 22nd, 2010, 03:40 PM
Old Pedant Old Pedant is offline
Friend of Wrox
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

CAUTION: None of these queries are going to be very efficient unless you have the right indexes in place!! What are "right indexes"? It depends on the DB. MySQL is especially fussy about indexes for something like this.
Reply With Quote
The Following User Says Thank You to Old Pedant For This Useful Post:
03jh01 (December 22nd, 2010)