How to get only Messages where some specific custom field have value?

Hi Team, I have a custom field added by Khoros in the messages object, I want to get only Messages where that specific custom field has value. Sample query: select c_abcd from messages where c...