operation on column in SQL

Question

I have a table in SQL database, where one column contains the character "C" or "P". I want to define a new column, where the value is 1, if this character is "C" and zero otherwise.

kind regards, Daniel

Answer 1

if you want to define through projection, try

SELECT columnName, IF(columnName = 'C', 1, 0) newValue
FROM tableName

As an alternative suggested by Michael Berkowski,

SELECT columnName, (columnName = 'C') newValue
FROM tableName