php - 在 mysql 中搜索 WHERE NOT 函数来查找字符串？

Question

我得到以下 Mysql 命令:

// Call on a random style ID to display in rating window which user hasn't seen yet.

$resultSet = $conn->query("SELECT pictureID,userID FROM styles WHERE NOT 
viewedByUser = (NOT LIKE '%$userID%')  ORDER BY RAND() LIMIT 1");
while($rows = $resultSet->fetch_assoc() ){
    $rateableUserID = $rows['userID'];
    $rateablePictureID = $rows['pictureID'];
}

我想使用 WHERE NOT 函数在不包含与变量 $userID 相同的字符串的字符串后搜索字段“viewedByUser”。

我在这里有什么选择？

Answer 1

试试这个:-

$resultSet = $conn->query("SELECT pictureID,userID FROM styles WHERE
viewedByUser NOT LIKE '%$userID%'  ORDER BY RAND() LIMIT 1");
while($rows = $resultSet->fetch_assoc() ){
    $rateableUserID = $rows['userID'];
    $rateablePictureID = $rows['pictureID'];
}