Hyphenate when value is 0 in select

Question

How can I do in the mysql one query (SELECT) so that when the value is equal to 0, replace it with hífen(-).

Field of value: int.

Answer 1

You can use a IF in consultation.

The IF receives three "parameters", the first is the condition, the second is the value that the column will assume if the condition is met and the third is the value that the column will assume otherwise.

Select If(Campo = 0, '-', Campo) From Tabela 

IF documentation

Answer 2

@Eduardo Santos,

If you want to exchange the 0 for the hyphen in a select you do so:

SELECT IF(seu_campo = 0, '-', seu_campo) AS nome_para_esse_resultado FROM sua_tabela;

Answer 3

Select IIF(Campo = 0, '-', campo) AS CAMPOSELECIONADO from TABELA

That would work for your case.