Help Needed: Query refuses to order by Field()

[WilliamC]

Hello everyone, I have a unioned query that does not wish to allow ordering by field for some reason. The query itself is:

 

(SELECT * FROM jobs_table_local WHERE (`cID`="1280" OR `scID`="1280") AND `city`="192" AND `state`="319") 
UNION 
(SELECT * FROM jobs_table_imported WHERE (`cID`="1280" OR `scID`="1280") AND `city`="192" AND `state`="319") 
ORDER BY Field(title, 'cna') 

 

where the 'cna' would be the keyword searched by. The intention of how this should work would be to return the results with any results where field 'title' contains the keyword 'cna' first, then all other results afterwards.

 

 

[fenway]

I don't understand -- what do you men "not allowing".