Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Products: CMS Builder:
where statement - if a specific field is not blank

 
 


zip222
User

Nov 18, 2011, 5:51 PM

Post #1 of 2 (1605 views)
Shortcut
where statement - if a specific field is not blank Can't Post
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? :)


(This post was edited by zip222 on Nov 20, 2011, 5:56 AM)


Dave
Staff / Moderator


Nov 18, 2011, 9:16 PM

Post #2 of 2 (1589 views)
Shortcut
Re: [zip222] where statement - if a specific is not blank [In reply to] Can't Post
Hi zip222,

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

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

Hope that helps!

Dave Edis - Senior Developer
interactivetools.com