I'm trying to run a MySQL query, but it seems to be ignoring the "ORDER BY" clause, most likely, I'm believing, because I'm using the "IN" keyword in my query (several times, as a matter of fact, along with a "LIKE"). Is there a way I can structure my query, so that it will use the "ORDER BY" clause? I've included an example of the query below:
SELECT * FROM Ships, Accounts WHERE Available_Loads.Action != 'D' AND Ships.Username = Accounts.Username AND Ships.Username != 'demo' AND Ships.Status != 'inactive' AND Ships.PU_Date >= CURRENT_DATE() AND Ships.Shipment_Type LIKE '%' AND Ships.Required_Equipment IN ('AC', 'DD') AND Ships.Origin_Country IN ('USA') AND Ships.Origin_State IN ('TX') AND Ships.Origin_City IN ('ALLEN', 'ARGYLE', 'ARLINGTON', 'AUBREY', 'BEDFORD', 'CARROLLTON', 'CEDAR HILL', 'CELINA', 'COLLEYVILLE', 'COPPELL', 'DALLAS', 'DENTON', 'DESOTO', 'DUNCANVILLE', 'EULESS', 'FLOWER MOUND', 'FORT WORTH', 'FRISCO', 'GARLAND', 'GRAND PRAIRIE', 'GRAPEVINE', 'HURST', 'IRVING', 'KELLER', 'LAKE DALLAS', 'LAVON', 'LEWISVILLE', 'LITTLE ELM', 'MCKINNEY', 'MELISSA', 'MESQUITE', 'NORTH RICHLAND HILLS', 'PLANO', 'PRINCETON', 'PROSPER', 'RICHARDSON', 'ROANOKE', 'ROWLETT', 'SOUTHLAKE', 'SUNNYVALE', 'THE COLONY', 'WYLIE') AND Ships.Dest_Country IN ('USA') AND Ships.Dest_State IN ('LA') ORDER BY 'PU_Date ASC'
Thanks for any suggestions you can provide!