https://www.youtube.com/watch?v=5Kw2ZygupRw

DROP TABLE IF EXISTS Test 
CREATE TABLE Test (ID INT,Name varchar(15)) 

INSERT INTO Test 
VALUES (1,'John'), (2,'Jacob'), (3,'Alice'), (4,'Bob') 

SELECT * FROM Test

WHERE NOT EXISTS

SELECT 'No Data' AS ID,'No Data' AS Name 
WHERE NOT exists(
SELECT * FROM Test
where id=0
)

SELECT 
	ifnull(B.ID,A.ID) AS ID,
	ifnull(B.Name,A.Name) AS Name
FROM 
(
SELECT 'No Data' AS ID, 'No Data' AS Name ) A
LEFT JOIN 
(
	SELECT ID,Name FROM test where ID < 0 
) B
ON 1=1