Search code examples
phpmysqlsql-match-all

is there a mysql clause for multiple and statements like IN?

is there an easy way to do multiple AND statments like the IN clause does for OR?

Solution

  • Is not possible in general,
    a column can only store one value,
    you won't have a situation when status = 1 AND status =2

    The exception case is set data type