SELECT
`field`. fieldtype,
`field`.display_mechanism,
customdefinedfield.cdf_datatype,
Count(`field`.field_guid)
FROM
customdefinedfield
Inner Join `field` ON `field`.cdf_guid = customdefinedfield.cdf_id
GROUP BY
`field`.fieldtype,
`field`.display_mechanism,
customdefinedfield.cdf_datatype
ORDER BY
`field`.fieldtype ASC,
`field`.display_mechanism ASC,
customdefinedfield.cdf_datatype ASC
----------------------------------------------------------------------
UPDATE `field`
SET `field`.display_mechanism = NULL
WHERE `field`.display_mechanism = ''