Select brings different results

Question

I’m having a problem at a SELECT:

SELECT * FROM documento WHERE idAdministrador = '1' AND modulo = 'funcionario' OR modulo = 'atestado'

I need you, if module is working or attested, to do the correct search... However, it does not search for those who have idAdministrator = '1', the query base is the module only... Returns independent of idAdministrator being 1 or not.

How do I make a SELECT to search for the ID first, and if it’s working module or attested, list it correctly?

Answer 1

Group sql conditions with ():

SELECT * 
FROM 
    documento 

WHERE 
    idAdministrador = '1' 
    AND (modulo = 'funcionario' OR modulo = 'atestado')

Otherwise it was probably being interpreted as idAdminstrador=1 e modulo='funcionario or modulo='atestado'.