Test3 status query

SELECT 
    IIF (LOWER(common_name) LIKE '%frog%', 'frog', 'notfrog') AS STATUS,
    common_name AS RESULT
FROM species
WHERE LOWER(common_name) LIKE '%frog%'
LIMIT 1;

<div style="background-color: #D5E8D4">Frog: :result</div>

<div style="background-color: #F8CECC">No frog found: :result</div>