SELECT * FROM staff s
WHERE
    s.status = 0
    AND login_name LIKE '%“c’†%'
ORDER BY staff_id