Select with 3 conditions and one dependent on a fourth condition

Question

I am populating a chart and for that I need to select the data of each user in the database, table financeiro. Still don’t want to show field records label_chart that are empty, nor fields qdade_stream with a zero value, unless the field label_chart = inicio (in that case the field qdade_stream can have zero value).

SELECT * FROM financeiro WHERE id_usuario = 150 AND label_chart !='' AND (qdade_stream != 0 AND label_chart <>'inicio')
ORDER BY order_chart";

The way I am doing, the query does not return the line whose label_chart=inicio, because its value is zero, the query only obeys the condition of only returning qdade_stream != 0

Answer 1

The logic of your query is almost right, only got a little confused in the operators you will use. As it has two conditions that make it possible to display result the ideal will be to use the OR, then I would be:

SELECT * 
FROM financeiro 
WHERE id_usuario = 150 
  AND ((label_chart != '' AND qdade_stream != 0) OR label_chart = 'inicio')
ORDER BY order_chart;

That way he picks up the records with id_registro = 150 and with label_chart and qdade_strem different from void or zero OR just with label_chart equal to the start without taking into account the qdade_stream.