How get null result if not found in Mysql

How get null result if not found in Mysql

omid_student
Omid Aghakhani
Posts: 381
Threads: 119
Joined: May 2015
Reputation: 0

01-13-2022, 02:21 AM

(01-13-2022, 02:01 AM)nfaiz Wrote: 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)

Not working and actually that is not logical query

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