Is CASE WHEN appropriate for optional parameters in a SQL query?
11598
Building where clause based upon parameters
88326
Check Constraint with Case Statement
115927
Parameterized Query for MySQL with C#
94883
Why does comparing a SQL date variable to null behave in this way?
70950
Using tsql greater than sign in CASE Expression
85189
MySQL: is a SELECT statement case sensitive?
155730
Create a function with optional arguments in MySQL
18538
Optional parameter in newcommand
127800
SQL: Using NULL values vs. default values
93041
using nulls in a mysqli prepared statement
143342
SQL function as default parameter value?
51536
Concatenate fields in SOQL queries in the WHERE clause (no Apex)
74025
Making extra parameters optional
89756
Using a variable instead of a parameter index with a JDBC prepared statement
65115
Alter a Views query to use "OR" through the user interface
93409
Any way to specify optional parameter values in PHP?
81578
How do you create optional arguments in php?