开发者

Can I use multiple parameters when using WHERE in MYSQL

开发者 https://www.devze.com 2023-04-11 11:29 出处:网络
(when selecting data from tables in MYSQL database) something like this: WHERE some_column = some_value, other_column = other_value

(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 r开发者_如何转开发ather than going into "if loops"


Yes, just separate them with ANDs:

WHERE some_column=some_value AND other_column=other_value


WHERE some_column = some_value AND other_column = other_value
0

精彩评论

暂无评论...
验证码 换一张
取 消