MySQL Forums
Forum List  »  PHP

Multiple Conditional WHERE Conditions
Posted by: Paul Maher
Date: July 11, 2021 07:04PM


How does one one write multiple conditional WHERE clauses where any values that are null are not part of the query

Like this but where each one is only part of the where clause if the value is not null

SELECT * FROM table WHERE col1 = ? AND col2 = ? AND col3 = ? AND col4 = ?

Options: ReplyQuote

Written By
Multiple Conditional WHERE Conditions
July 11, 2021 07:04PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.