How to fix a query in the database?

Question

PHP

I have a table in the database, it has two enum fields:
1. photo = has the values ​​yes or no
2. video = has the same values ​​yes or no
There is a task to write a query that would select all records that have photo or video marked with the value yes .
So far I've thought of this:

$result = $mysql->query("SELECT * FROM news WHERE photo = 'yes' AND video = ' yes'");

But there is one problem, the query selects all records in which two fields have the value yes.
How to rewrite it to select all records, even if video = 'yes' in one record, and photo = 'no' in another record... ?

Answer 1

Do you understand the difference between AND and OR?

Answer 2

photo = 'yes' AND video = ' yes'
gives records where photo and video are both yes
photo = 'yes' OR video = ' yes'
gives records where either photo and video are both yes or either of the photo and video fields is yes

Answer 3

result = $mysql->query("SELECT * FROM news WHERE photo = 'yes' OR video = ' yes'");

Answer 4

result = $mysql->query("SELECT * FROM news WHERE photo = 'yes' OR video = ' no'");