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

BubikolRamios · 11-24-2012, 10:48 PM

What does this shows ?

Code:

EXPLAIN SELECT type FROM orderhistory WHERE (order_id = '943581' OR ticket_id = '943581') AND visible = 'Y' limit 1

11-24-2012, 10:48 PM	PM User \| #2
BubikolRamios Senior Coder Join Date: Dec 2005 Location: Slovenia Posts: 1,876 Thanks: 114 Thanked 76 Times in 76 Posts	What does this shows ? Code: EXPLAIN SELECT type FROM orderhistory WHERE (order_id = '943581' OR ticket_id = '943581') AND visible = 'Y' limit 1 __________________ Found a flower or bug and don't know what it is ? agrozoo.net galery if you don't spot search button at once, there is search form: agrozoo.net galery search