MYSQL selecting or showing record based on 2 different values in the same field

[admin]

USE the OR attribute

Tells the query to look for this OR that value

SELECT *
FROM status_options_various
WHERE menu_group = 8 (this)
OR menu_group = 9 (that)

This will combine the output together and show both


To select values from 2 different fields use the AND attribute - Select This AND This

SELECT *
FROM status_options_various
WHERE menu_group = 8 (this)
AND menu_tax = 9 (this)