Search code examples
mysqldatabasenpgsql

Three column conditions in database


Is it possible to get 3 column names as conditions in database?

ex:

SELECT * FROM table WHERE column1=value1, column2=value2, column3=value3

Solution

  • with and clause

     SELECT * FROM table 
     WHERE column1=value1
     and  column2=value2
     and  column3=value3;