`field`.display_mechanism ASC,
customdefinedfield.cdf_datatype ASC
</pre>
This UPDATE query is just one of several that might need to be applied
<pre>
Update `field`
SET `field`.display_mechanism = null
where `field`.display_mechanism = '' AND
`field`. fieldtype = 'cdf'
</pre>