MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.21


create table dms_document (dms_doc_name varchar(20), dms_category_id int, dms_subcategory_id int, dms_expire_date date);
insert into dms_document
select 'esaki', 6, 2, '2020-01-01'
union all
select 'testie', 5, 4, '2020-04-01'
union all
select 'Dms Doc Name', 6, 2, '2020-07-01'
union all
select 'Esakki', 6, 2, '2020-07-13'
SELECT * 
FROM dms_document
WHERE dms_expire_date BETWEEN '2020-05-01' AND '2020-07-16'


dms_doc_name
dms_category_id
dms_subcategory_id
dms_expire_date


Dms Doc Name
6
2
2020-07-01

Esakki
6
2
2020-07-13


SELECT * 
FROM dms_document
WHERE NOT dms_expire_date BETWEEN '2020-05-01' AND '2020-07-16'
AND dms_doc_name = 'testie'


dms_doc_name
dms_category_id
dms_subcategory_id
dms_expire_date


testie
5
4
2020-04-01


SELECT * 
FROM dms_document
WHERE NOT dms_expire_date BETWEEN '2020-05-01' AND '2020-07-16'
AND dms_doc_name = 'testie'
OR CASE WHEN NULL IS NULL THEN 1 = 1 ELSE dms_category_id = NULL END 
OR CASE WHEN NULL IS NULL THEN 1 = 1 ELSE dms_subcategory_id = NULL END 


dms_doc_name
dms_category_id
dms_subcategory_id
dms_expire_date


esaki
6
2
2020-01-01

testie
5
4
2020-04-01

Dms Doc Name
6
2
2020-07-01

Esakki
6
2
2020-07-13

dms_doc_name	dms_category_id	dms_subcategory_id	dms_expire_date
esaki	6	2	2020-01-01
testie	5	4	2020-04-01
Dms Doc Name	6	2	2020-07-01
Esakki	6	2	2020-07-13