Jump to content


Photo

Easy select ?


  • Please log in to reply
1 reply to this topic

#1 aveach

aveach
  • Members
  • Pip
  • Newbie
  • 5 posts

Posted 26 January 2003 - 03:34 AM

I need to select all the records in my table that have entries in a particular column. Like
Select * from bar_info where bar_website=notnull
I just want to display all the records that have entries in the bar_website column.
Obviously I\'m new, Please help. Thanks

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 26 January 2003 - 03:52 AM

select * from bar_info where bar_website is not null;
select * from bar_info where bar_website!=NULL;

i think either will do. i hope my syntax is right... i haven\'t sql\'ed in awhile :shock:
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users