So I want to make an update in MySQL where a value is updated if two conditions are true. So I have data in columns name and status. If the name and status match foo and d, then I want to change ...

If it matters, I'm using PHP, but I'm pretty sure I just need help with the actual MySQL query.I'm going to be building a table in MySQL with user information. What I'd like to do is select 50 ...