where statement - if a specific field is not blank

2 posts by 2 authors in: Forums > CMS Builder
Last Post: November 19, 2011   (RSS)

By zip222 - November 18, 2011 - edited: November 20, 2011

I need help with a where statement. I want to pull all records where a specific field is not blank. The field is a 'text field'.

'where' = > 'fieldname IS NOT BLANK',

Help? :)

Re: [zip222] where statement - if a specific is not blank

By Dave - November 19, 2011

Hi zip222,

Try this:
'where' = > " fieldname != '' ",

In MySQL = means "equals" and != means "not equal".

Hope that helps!
Dave Edis - Senior Developer
interactivetools.com