MySQL select查询

Question

我有一个简单的MySQL查询，根据两个要求从表中选择所有列。

`$dbSearchRecords = mysql_query("SELECT * FROM booking WHERE BookingID = '$JobNo_search' AND Date BETWEEN '$DateFrom_search' AND '$DateTo_search'")` 

我想获得查询来搜索一个或两个要求。 WHERE BookingID ='$ JobNo_search'与'$ DateFrom_search'AND'$ DateTo_search'之间的日期

目前所有参数都需要存在才能得到结果，我需要能够仅搜索BookinID或日期范围。

干杯家伙。

Answer 1

怎样......

$dbSearchRecords = mysql_query(

    "SELECT * FROM booking 
    WHERE BookingID = '$JobNo_search' 
    OR (Date BETWEEN '$DateFrom_search' AND '$DateTo_search') 
    OR itemid = $itemID 
    OR job_no = $job_no 
    OR rego = $rego 
    " 

) 

的OR工作作为AND/OR。