mysql EXPLAIN

[jpr]

Hey, I am trying to figure out how to optimize my queries, so I wanted to see how they were working by using the EXPLAIN function. However I cannot get it to work. Here is an example query:

$defaultQuery = "EXPLAIN (SELECT * FROM hd_tickets WHERE (priority = 'urgent' AND status = '" . $type . "' AND assigned_to = '" . $dep . "'";
				if ((!isset($_COOKIE['showResolved'])) || ($_COOKIE['showResolved'] != "yes")) { $defaultQuery .=" AND new = '1'"; }
				$defaultQuery .= ") ORDER BY create_timestamp ASC)";
				$defaultQuery .="UNION";
				$defaultQuery .="(SELECT * FROM hd_tickets WHERE (priority = 'high' AND status = '" . $type . "' AND assigned_to = '" . $dep . "'";
				if ((!isset($_COOKIE['showResolved'])) || ($_COOKIE['showResolved'] != "yes")) { $defaultQuery .=" AND new = '1'"; }
				$defaultQuery .=") ORDER BY create_timestamp ASC)";
				$defaultQuery .="UNION";
				$defaultQuery .="(SELECT * FROM hd_tickets WHERE (priority = 'normal' AND status = '" . $type . "' AND assigned_to = '" . $dep . "'";
				if ((!isset($_COOKIE['showResolved'])) || ($_COOKIE['showResolved'] != "yes")) { $defaultQuery .=" AND new = '1'"; }
				$defaultQuery .=") ORDER BY create_timestamp ASC)";
				$defaultQuery .="UNION";
				$defaultQuery .="(SELECT * FROM hd_tickets WHERE (priority = 'low' AND status = '" . $type . "' AND assigned_to = '" . $dep . "'";
				if ((!isset($_COOKIE['showResolved'])) || ($_COOKIE['showResolved'] != "yes")) { $defaultQuery .=" AND new = '1'"; }
				$defaultQuery .=") ORDER BY create_timestamp ASC)";


mysql_query($defaultQuery);

[Roger_Ramjet]

Well, I'm not sure about tha actual query you are building because your first problem is the ( before select : not needed with explain . Check the manual for that.