mysql check if not null

Abbas Amiri

Code: SQL

2021-08-13 05:53:10

SELECT * 
FROM table 
WHERE YourColumn IS NOT NULL;

LibraFranca

Code: SQL

2021-03-21 15:11:58

SELECT *
FROM contacts
WHERE last_name IS NULL;

Ian_E

Code: SQL

2021-03-21 15:09:25

SELECT * from TABLE where CODE IS NULL OR CODE!='C'

Kaushik

Code: SQL

2021-03-21 15:10:51

 SELECT 
    contactname, IFNULL(bizphone, homephone) phone
FROM
    contacts;

New to Communities?

Join the community