[Solved] How to get rows of a specific type matching a specific value?

Do you mean something like that?

SELECT * From ProviderDxCptCodes WHERE CodeType="CPT" AND name LIKE '%flu%';