MySQL query Selecting records from a database where the value is equal to one of two different things

Question

I need to get records from my MySQL database, where:

sentto = "$username"

OR

sentto = "everyone"

How would I put this in a MySQL query? I tried a few things, but they don't seem to work:

mysql_query("SELECT * 
             FROM pmessages 
             WHERE status='unread' 
                 AND sentto='$username' || sentto='everyone'");

mysql_query("SELECT * 
             FROM pmessages 
             WHERE status='unread' 
             AND sentto='$username' 
                 AND sentto='everyone'");

I seem to be at a dead end, if someone knows how to do it right, please let me know. This is a new scenario for me. Thanks!

Answer 1

SELECT * 
FROM pmmessages 
WHERE sentto = '$username' 
    OR sentto = 'everyone'

Change Chris based on your new request:

SELECT * 
FROM pmessages 
WHERE status='unread' 
    AND sentto='$username' 
OR sentto='everyone' 

You need to change it so that your AND stands alone (it contradicts your OR).

Rewrite it on this

SELECT * 
FROM pmessages 
WHERE status='unread' 
    AND 
        (sentto='$username' 
            OR sentto='everyone' )

Answer 2

- "OR" , , .

SELECT * FROM pmessages WHERE
   status = 'unread'
    AND
  (sentto = ? OR sentto = 'everyone')

OR, AND . , , - "status = unread".

? - MySQL PHP, ..

$sql = "..." # as above
$sth = $db->prepare($sql);
$res = $sth->execute($username);
while ($row = $sth->fetchrow()) {
    ...
}

( mysqli)

Answer 3

, , IN:

SELECT * 
FROM pmessages 
WHERE status='unread' 
AND sentto IN ('everyone', '$username');

Answer 4

OR - , :

mysql_query ( "SELECT * FROM pmessages WHERE sentto = '$ username' OR sentto = 'every'" );

Answer 5

?

if you want to return all the results, configure something like this

if (@sentto is null)
begin

     set @sendto='%'

end

mysql_query("SELECT * FROM pmessages WHERE sentto='$username'")