How get null result if not found in Mysql

How get null result if not found in Mysql

nfaiz
Member
Posts: 50
Threads: 6
Joined: Apr 2015
Reputation: 3

01-13-2022, 02:01 AM

SELECT * FROM tbl_order WHERE DATE(order_date) IN ('2021-01-01','2021-01-02','2021-01-03','2021-01-04','2021-01-05') OR order_date IS NULL GROUP BY DATE(order_date)

Messages In This Thread

How get null result if not found in Mysql - by omid_student - 01-11-2022, 10:50 PM

RE: How get null result if not found in Mysql - by php_rocs - 01-12-2022, 07:33 AM

RE: How get null result if not found in Mysql - by omid_student - 01-12-2022, 08:12 AM

RE: How get null result if not found in Mysql - by php_rocs - 01-12-2022, 12:16 PM

RE: How get null result if not found in Mysql - by omid_student - 01-12-2022, 10:32 PM

RE: How get null result if not found in Mysql - by nfaiz - 01-13-2022, 02:01 AM

RE: How get null result if not found in Mysql - by omid_student - 01-13-2022, 02:21 AM