Replace number by string in the results

Question

Replace number by string in the results

Navigation

#1 by (1 votes)
#2 by (0 votes)

0

I have the following query:

SELECT 
sum(pedidos_lentes.quantidade) AS value, 
pedidos_lentes.solar AS label FROM pedidos 
JOIN pedidos_lentes ON pedidos_lentes.id_pedido = pedidos.id_pedido 
WHERE id_loja = 2
group by pedidos_lentes.solar

The label column returns values 1 and 0 stored in the database. In the result, can you exchange these values with strings?

mysql

asked by anonymous 04.05.2016 / 20:15

2 answers

Sending form via Ajax in Laravel + Request How to scan an array of a variable and compare it to another variable? [duplicate]

score 1 · Answer 1

Resolved:

SELECT 
sum(pedidos_lentes.quantidade) AS value, 
CASE pedidos_lentes.solar WHEN 1 THEN 'Yes' ELSE 'No' END AS label 

FROM pedidos 

JOIN pedidos_lentes ON pedidos_lentes.id_pedido = pedidos.id_pedido 
WHERE id_loja = 2
group by pedidos_lentes.solar

score 0 · Answer 2

Friend, see if it helps:

SELECT 
sum(pedidos_lentes.quantidade) AS value,
CAST(pedidos_lentes.solara as CHAR(1)) AS label,
JOIN pedidos_lentes ON pedidos_lentes.id_pedido = pedidos.id_pedido 
WHERE id_loja = 2
group by pedidos_lentes.solar