MySQL Forums
Forum List  »  PHP

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

hello,

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


Subject
Written By
Posted
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.