Optimize SQL Query

[Sulphy]

Hi,

I'm using this query in order to collate information on screen that meet two criterias' - 'Ordered' and 'Awaiting Confirmation'.

$sql = "SELECT *, DATE_FORMAT(inputdate, \"%d %M %Y\") AS inputdate FROM tblOrders WHERE status='Ordered' and ClientAC = " . $HTTP_SESSION_VARS["AccNum"] ." or status ='Awaiting Confirmation' and ClientAC = " . $HTTP_SESSION_VARS["AccNum"];

Does anyone know how i could optimize this query so that i don't have to restate the ClientAC condition?

Thanks in advance.

[trexx]

how about that?

SELECT *, 
	DATE_FORMAT(inputdate, '%d %M %Y') AS inputdate 
FROM 
	tblOrders 
WHERE 
		  ClientAC = $clientAC 
	AND status IN('Ordered', 'Awaiting Confirmation');

of course that doesn't really optimize the query. you can check the performance of every query if you type EXPLAIN SELECT... in mySQL. you'll find a lot information about optimizing queries here:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#Query_Speed

[Weedpacket]

One of the biggest optimisations I can see is to not use SELECT * unless you really do want every field in the record. If you don't, just ask for the fields you do want.