SQL query statement: SELECT * from Table wher A B C D

Request a SQL query statement: SELECT * from Table wher a B C D
SELECT * from Table wher A and B and C and D

Among them, A,b,c,d is the condition. How should it be constructed?

is not to judge A,b,c,d, as long as there is a not empty, then the "where"

And what about it? 》

------Solution--------------------
Determines non-null, misspelled SQL strings. Typically, where and a are not present, where and A are 1=1.
------Solution--------------------
Hookee () Positive solution
------Solution--------------------
Hookee () Positive solution

where 1=1 and where 1! = 1 are often used in SQL

1=1 for the back add things to pave, 1! = 1 Get the structure of the table
------Solution--------------------
$aWhere [] = "1=1";
if (!empty ($A))
$aWhere [] = $A;
if (!emtpy ($B))
$aWhere [] = $B;
if (!empty ($C))
$aWhere [] = $C;
if (!empty ($D))
$aWhere [] = $D;

$sWhere = Join (' and ', $aWhere);
$SSQL = "SELECT * from the TBL where $sWhere order by id DESC";

------Solution--------------------
$condition = "";
$link _symbol = "";
if ($a)
{
$condition. = "$link _symbol $a";
$link _symbol = "and";
}
In turn

