Can I use multiple parameters when using WHERE in MYSQL

Question

(when selecting data from tables in MYSQL database) something like this:

WHERE some_column = some_value, other_column = other_value

If not, Is there other simple method rather than going into "if loops"

What's wrong with using WHERE some_column=some_value AND other_column=other_value? Or am I missing something? — Aleks G
– Aleks G, Commented Oct 6, 2011 at 16:26
if is not a loop and there is nothing wrong in them anyway. most of time you have to use if statements to create a dynamical mysql query. — Your Common Sense
– Your Common Sense, Commented Oct 6, 2011 at 16:31

Viktor · Accepted Answer · 2011-10-06 16:25:59Z

7

Yes, just separate them with ANDs:

WHERE some_column=some_value AND other_column=other_value

answered Oct 6, 2011 at 16:25

Viktor

3,5561 gold badge36 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

You can also use OR depending on the logical result you are trying to achieve.

Cade Roux · Accepted Answer · 2011-10-06 16:25:55Z

3

WHERE some_column = some_value AND other_column = other_value

answered Oct 6, 2011 at 16:25

Cade Roux

90.1k42 gold badges186 silver badges268 bronze badges