Khaled Mahmoud
Reputation: 302
Can I use multiple parameters when using WHERE in MYSQL
(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"
Upvotes: 0
Views: 143
Answers (2)
Viktor
Reputation: 3536
Yes, just separate them with ANDs:
WHERE some_column=some_value AND other_column=other_value
Upvotes: 7
Related Questions
- Multiple where clause in sql statement?
- MySQLl one or multiple parameters in where clause
- SQL query with multiple parameters in where
- multiple where statements in mysql query
- Mysql Multiple Arguments for "Where" Clause
- Can I use two Where in select statement
- Multiple parameters in where clause
- Can I use multiple WHERE statements in one MySQL query?
- Using more than one WHERE condition in mysql query
- Using two variables from PHP on the same WHERE in MySQL