Как использовать WHERE в MYSQL?

, WHERE MYSQL, , . , . , .

Where SELECT, UPDATE, INSERT, DELETE.

, , .

:

WHERE conditions;
      
      

        
        
        
      

    
        
        
        
      
      

        
        
        
      

    
    

Conditions - .

.

where MYSQL , .

, . .

SELECT * 
FROM users //  users
WHERE name = "" AND lastname = ""; //        
      
      

        
        
        
      

    
        
        
        
      
      

        
        
        
      

    
    

, AND, , WHERE .

OR:

SELECT * 
FROM users //  users
WHERE name = "" OR lastname = ""; //        
      
      

        
        
        
      

    
        
        
        
      
      

        
        
        
      

    
    

, .

. :

SELECT * 
FROM users //  users
WHERE name = ("" AND lastname = "";)
OR (patronymic = "")
      
      

        
        
        
      

    
        
        
        
      
      

        
        
        
      

    
    

, - OR AND.

, , .

where , .

WHERE - . AND OR, , .

, - , , , , .