_Problem #1_: How do I simplify my mySql where queries?
_Problem #2_: How can I search through an array in my where statement?
Answer: An awesome trick when it comes to querying multiple where clauses is to use the WHERE <…> IN command.
$id = ‘1,4,3,6,8,2′;
“SELECT * FROM <…> WHERE id IN ($id)”
Oh and did I mention you can prepend the NOT statement to show results which is NOT included in the list?
$id = ‘5,7′;
“SELECT * FROM <…> WHERE id NOT IN ($id)”
Oh-Some!
Still can't see what you're looking for?
