How to Implement this to mysql query?

Question

With one select command, display all cats with male sex and dogs whith female sex

i'have tried select * from pet where species='cat' && sex='m' | species='dog' && sex='f';

beware of || deprecation use OR dev.mysql.com/doc/refman/8.0/en/logical-operators.html — P.Salmon
– P.Salmon, Commented Mar 26, 2020 at 12:05

Gordon Linoff · Accepted Answer · 2020-03-26 12:03:53Z

1

You connect boolean expressions in SQL using AND and OR, not strange operators lifted from C:

where (species = 'cat' and sex = 'm') or
      (species = 'dog' and sex = 'f');

MySQL also supports IN with tuples:

where (species, sex) in ( ('cat', 'm'), ('dog', 'f') );

And just to clarify: MySQL does understand && and || as real boolean operators. I strongly discourage anyone from using this (mostly my general preference for standards when they are equivalent). However, & and | are bitwise operators, so they may not do what you expect in a boolean context.

edited Mar 26, 2020 at 12:03

answered Mar 26, 2020 at 12:03

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

1 Comment

t1f Over a year ago

"strange operators lifted from C:" I loved that. hahaha!

Collectives™ on Stack Overflow

How to Implement this to mysql query?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related