in reply to Substitute "Yes" for "1" in mysql query output?

You could just amend the sql

SELECT updated,
       if (preauth,'Yes','No') as preauth,
       patient, evidence,staff
FROM facts
WHERE cpt = ? AND insco = ?

[download]
poj

Replies are listed 'Best First'.
Re^2: Substitute "Yes" for "1" in mysql query output?
by abner (Novice) on Jan 25, 2017 at 23:09 UTC
    I tried this. It works and I think it makes my code look better. Thank you.
[reply]

In Section Seekers of Perl Wisdom