You should useIS NOT NULL. (The comparison operators= and<> both giveUNKNOWN withNULL on either side of the expression.)

SELECT * FROM table WHERE YourColumn IS NOT NULL;

Just for completeness I'll mention that in MySQL you can also negate thenull safe equality operator but this is not standard SQL.

SELECT *FROM table WHERE NOT (YourColumn <=> NULL);

Edited to reflect comments. It sounds like your table may not be in first normal form in which case changing the structure may make your task easier. A couple of other ways of doing it though...

SELECT val1 AS valFROM  your_tableWHERE val1 IS NOT NULLUNION ALLSELECT val2 FROM  your_tableWHERE val2 IS NOT NULL/*And so on for all your columns*/

The disadvantage of the above is that it scans the table multiple times once for each column. That may possibly be avoided by the below but I haven't tested this in MySQL.

SELECT CASE idx         WHEN 1 THEN val1         WHEN 2 THEN val2       END AS valFROM   your_table        /*CROSS JOIN*/       JOIN (SELECT 1 AS idx                   UNION ALL                   SELECT 2) tHAVING val IS NOT NULL  /*Can reference alias in Having in MySQL*/

You can filter out rows that contain a NULL value in a specific column:

SELECT col1, col2, ..., colnFROM yourtableWHERE somecolumn IS NOT NULL

If you want to filter out rows that contain a null in any column then try this:

SELECT col1, col2, ..., colnFROM yourtableWHERE col1 IS NOT NULLAND col2 IS NOT NULL-- ...AND coln IS NOT NULL

Update: Based on your comments, perhaps you want this?

SELECT * FROM(    SELECT col1 AS col FROM yourtable    UNION    SELECT col2 AS col FROM yourtable    UNION    -- ...    UNION    SELECT coln AS col FROM yourtable) T1WHERE col IS NOT NULL

And I agre with Martin that if you need to do this then you should probably change your database design.

Select * from your_table WHERE col1 and col2 and col3 and col4 and col5 IS NOT NULL;

The only disadvantage of this approach is that you can only compare 5 columns, after that the result will always be false, so I do compare only the fields that can beNULL.

I found this solution:

This query select last not null value for each column.

Example

If you have a table:

id|title|body1 |t1   |b12 |NULL |b23 |t3   |NULL

you get:

title|bodyt3   |b2

Query

SELECT DISTINCT (  SELECT title  FROM test  WHERE title IS NOT NULL   ORDER BY id DESC   LIMIT 1) title, (  SELECT body  FROM test  WHERE body IS NOT NULL   ORDER BY id DESC   LIMIT 1) bodyFROM test

I hope help you.

Following query working for me

when i have set default value of column 'NULL' then

select * from table where column IS NOT NULL

and when i have set default value nothing then

select * from table where column <>''

Yes useNOT NULL in your query like this below.

SELECT * FROM tableWHERE col IS NOT NULL;

I use the\! command within MySQL to grep out NULL values from the shell:

\! mysql -e "SELECT * FROM table WHERE column = 123456\G" | grep -v NULL

It works best with a proper.my.cnf where your database/username/password are specified. That way you just have to surround yourselect with\! mysql e and| grep -v NULL.

You didn't even have to use an asterisk to get the table fields.

Add condition >0 for int columns and != "" for varchar columns

select column1_id, column2, colummn3, where column1_id>0 and column2 != ""

SELECT duration,id FROM `tickets` WHERE duration !=""

WHERE COALESCE(ALL YOUR COLUMNS) IS NOT NULL

SELECT * FROM TABLE_NAMEwhere COLUMN_NAME <> '';

• mysql
• sql
• select
• notnull