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? :)
'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:
In MySQL = means "equals" and != means "not equal".
Hope that helps!
Try this:
'where' = > " fieldname != '' ",In MySQL = means "equals" and != means "not equal".
Hope that helps!
Dave Edis - Senior Developer
interactivetools.com
interactivetools.com