2
I have to perform a query to know if the code of a group is in the permissions to see the field.
SELECT *
FROM callcenter.pausa
WHERE habilitado = 1
AND permissao_ver::varchar ilike '%1%'
ORDER BY pausa ASC
Upshot:
{26,9,10,7,19,2,21,11,17,14,15,6,8,25,24,32,27,28,22,23,13,12,16}
This array does not have the number 1 but the same returns me data because there are other numbers with the digit 1, I need it to check that it really has the number 1.
If you want it to return you only the data that is the number one why is using the
like
?– R.Santos