Search WHERE NOT function in mysql for a string?

Question

I got the following Mysql command:

// 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'];
}

I want to use the WHERE NOT function to search through the field "viewedByUser" after a string that does not contain the same string as the variable $userID.

What options have I got here?

You are using double negation and you've got a syntax error too (= (NOT LIKE). Try to simply use the NOT LIKE operators. — Laposhasú Acsa
– Laposhasú Acsa, Commented Aug 10, 2017 at 7:56

Amit · Accepted Answer · 2017-08-10 07:48:19Z

1

Try This :-

$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'];
}

answered Aug 10, 2017 at 7:48

Amit

14210 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Milan Chheda · Accepted Answer · 2017-08-10 07:54:17Z

1

You can directly use != instead of NOT LIKE and there is nothing called WHERE NOT

$resultSet = $conn->query("SELECT pictureID, userID FROM styles WHERE viewedByUser != $userID ORDER BY RAND() LIMIT 1");

Since they are email addresses, you can do:

$userId = '[email protected] [email protected]';
$userId = explode(' ', $userId);
echo $userStr = implode("', '", $userId);
$resultSet = $conn->query("SELECT pictureID, userID FROM styles WHERE viewedByUser NOT IN ('" . $userStr . "') ORDER BY RAND() LIMIT 1");

edited Aug 10, 2017 at 7:54

answered Aug 10, 2017 at 7:45

Milan Chheda

8,2593 gold badges23 silver badges35 bronze badges

1 Comment

user6915268 Over a year ago

but the field 'viewedByUser' contains a long string with many emailadress which are seperated with a space. It doesn't recognise the variable $userID in that field and continious with the picked pictureID and userID :/

ScaisEdge · Accepted Answer · 2017-08-10 07:52:34Z

0

If you need a (not) like on the viewedByUser you can simply use

"SELECT pictureID,userID 
 FROM styles W
 WHERE viewedByUser = NOT LIKE '%$userID%' 
 ORDER BY RAND() 
LIMIT 1";

answered Aug 10, 2017 at 7:52

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Collectives™ on Stack Overflow

Search WHERE NOT function in mysql for a string?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related