query none null values in mysql

Question

I tried to implement the following mysql command try to get rows with none null values,

here is the table tbtext:

  id       text
     1 
     2     number2
     3     number3
     4     


   create table tbtext(
     id unsigned int auto_increment primary key,
     text char(7)
      )

I tried select * from tbtext where text is not null, but it returns the whole rows and doesn't return row 3 and row 4. I am new to mysql, can anyone help me with it, thanks in advance.

please paste your table definition by show create table tbtext — Paulo H.
– Paulo H., Commented Dec 3, 2011 at 17:10
Rows 3 and 4 have nothing in common. Is it a typo in the question? — Álvaro González
– Álvaro González, Commented Dec 3, 2011 at 17:11

Vincent Savard · Accepted Answer · 2011-12-03 17:09:20Z

1

I'm assuming text contains empty strings, and not NULL. The best thing to do would be to replace those empty strings with NULL, but you could also use this query :

-- ...
WHERE text <> '';

Please note however that empty strings are information, where NULL means lack of information. You should definitely not have empty strings if that's not what you're trying to do.

answered Dec 3, 2011 at 17:09

Vincent Savard

36.1k10 gold badges71 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

query none null values in mysql

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related