SELECT id , name FROM table WHERE f1='123'
UNION ALL
SELECT '无记录' as id , '无记录' as name FROM table WHERE Not Exists(
SELECT id , name FROM table WHERE f1='123'
) limit 1
SELECT id , name FROM table WHERE f1='123'
UNION ALL
SELECT '无记录' as id , '无记录' as name FROM table WHERE Not Exists(
SELECT id , name FROM table WHERE f1='123'
) limit 1