我可以在INSERT语句中使用WHERE子句吗？

Question

Is it possible to have a where clause in an insert statement? I can't find any documentation on this. I would like to do something like this:

$yesupdate2 = "INSERT INTO points(ID, 
SID,
WID,
PID) WHERE WID = :WID
VALUES(
:ID,
:SID,
:WID,
:PID)";
$stmt9 = $dbh->prepare($yesupdate2);
$stmt9->bindParam(':ID', $blurb, PDO::PARAM_INT);      
$stmt9->bindParam(':SID', $the_SID, PDO::PARAM_INT);        
$stmt9->bindParam(':WID', $yes_WID, PDO::PARAM_INT);        
$stmt9->bindParam(':PID', $contpoint, PDO::PARAM_INT);     
$stmt9->execute();

}
}

Answer 1

In an insert statement you wouldn't have an existing row to do a where claues on? You are inserting a new row, did you mean to do an update statment?

update users set ID=$wblurb and WID=$yes_WID WHERE WID = $wid 

Something like this would help..