You can probably use CASE in your query.

SELECT 
    CASE 
        WHEN FIELD3 LIKE '44%' THEN 'YES'
        ELSE 'NO'
    END AS Check_status
FROM table
GROUP BY Check_status;