How to find the object based on the field name?

The query works fine if ordinary single quotes are used: 

 Select Id, Namespaceprefix,developername,TableEnumOrId from customfield where developername LIKE '%(FIELDNAME)%' 

Otherwise you get :  

Unknown error parsing query