我找到了这个解决方案:

此查询为每列选择最后一个非空值。

例子

如果你有一张桌子:

id|title|body
1 |t1   |b1
2 |NULL |b2
3 |t3   |NULL

你会得到:

title|body
t3   |b2

查询

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
) body
FROM test

希望能帮到你。

哪里的coalesce(所有的列)不是空的

你可以过滤掉特定列中包含NULL值的行:

SELECT col1, col2, ..., coln
FROM yourtable
WHERE somecolumn IS NOT NULL

如果你想过滤掉任何列中包含null的行，那么试试这个:

SELECT col1, col2, ..., coln
FROM yourtable
WHERE col1 IS NOT NULL
AND col2 IS NOT NULL
-- ...
AND coln IS NOT NULL

更新:根据你的评论，也许你想要这个?

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

我同意Martin的观点，如果你需要这样做，那么你可能应该改变你的数据库设计。

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

SELECT * FROM TABLE_NAME
where COLUMN_NAME <> '';

是的，在你的查询中像下面这样使用NOT NULL。

SELECT * 
FROM table
WHERE col IS NOT NULL;