How could I select everything where a certain field is not empty / is not null?
Using MySQL 3.23
Thaniks!
Select Everything Where A Certain Field Is Not Empty?
Moderator: General Moderators
-
superwormy
- Forum Commoner
- Posts: 67
- Joined: Fri Oct 04, 2002 9:25 am
- Location: CT
alternative
if your empty defualt values are not NULL then the following will work
SELECT * FROM tableName WHERE fieldName <>''
phpScott'
SELECT * FROM tableName WHERE fieldName <>''
phpScott'
-
superwormy
- Forum Commoner
- Posts: 67
- Joined: Fri Oct 04, 2002 9:25 am
- Location: CT
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
Re: sorry
You can edit and delete your own postsphpScott wrote:sorry about the double message i noticed to late that I had missed the second quote
faq.php#15
Mac