CodingForums.com - View Single Post - Query help with a poorly structured table

shoryuken · 11-25-2012, 04:39 PM

So, I just thought of a really basic work around to reduce production load for now --

1) query for order_id = X AND visible2 = 1
2) query for ticket_id = X AND visible2 = 1
3) if either exists, continue

This solves it, I guess, but I'd really like to learn the correct solution with Mysql without kludging it with 2 separate queries

11-25-2012, 04:39 PM	PM User \| #8
shoryuken New Coder Join Date: May 2012 Posts: 17 Thanks: 2 Thanked 0 Times in 0 Posts	So, I just thought of a really basic work around to reduce production load for now -- 1) query for order_id = X AND visible2 = 1 2) query for ticket_id = X AND visible2 = 1 3) if either exists, continue This solves it, I guess, but I'd really like to learn the correct solution with Mysql without kludging it with 2 separate queries