Query using WHERE

Question

I need to make a query in a table called controls:

I have the spine CH which is the workload in minutes and I have the column SETOR which are the sectors that have participated in some training.

I need to make a query where brings me the total (sum) of minutes per sector. Sector 7 would be for example 1080 the result.

I did so: SELECT round(SUM(ch)) FROM controles WHERE setor = '7';

but it brings me no result.

Answer 1

If you want to find all the records where the field setor has certain number you would have to do so:

Note: Understanding that your field is Varchar or some other equivalent to the type of text (String).

SELECT round(SUM(ch)) FROM controles WHERE setor like '%"7"%';

Explaining

Example 1

Select * from Tabela where nome LIKE ‘a%’;

The above character %' indicates that we are seeking all names that start with the letter '.

Example 2

Select * from Tabela where nome LIKE ‘%a’;

The above character %' indicates that we are searching all the names that have the last letter.

Example 3

Select * from Tabela where nome LIKE ‘%a%’;

The two above characters' index indicates that we are searching all the names that have the letter ' a' in any part of the text.