Mysql query help

[gmc1103]

I have this table

 

  Field Type Comment idsala int(11) NOT NULL     sala varchar(45) NOT NULL     estado tinyint(1) NOT NULL

 

And i want to avoid 3 records from the database

 

I'm using this query but those records are showed

SELECT
    `idsala`
    , `sala`
FROM
    `req_material_sala`
WHERE (`idsala` !=23)
    OR (`idsala` !=24)
    OR (`idsala` !=39); 

Any help please?

 

[Barand]

Use AND instead of OR.

 

Alternatively,

... WHERE idsala NOT IN (23,24,39)

[gmc1103]

Hi Barand

 

Thank you again.

 

Best regards