I'm exporting a MySQL table to be used in Salesforce. There is a field for where the data is either set to a 1 or blank. I need to be able to have MySQL output this as a Y for 1 and a N for blank. Can this be done with MySQL or is it better to do this in PHP or must it be done in PHP?
I don't know MySQL well enough, is there something like IF field1 = "1" then field1="Y", else field1="N"? Thanks!