Reversed "IN" operator? Is that possible?

Question

Is it legit to switch operands in "IN" operator in MySQL? Just like that:

...thus effectively replacing multiple "OR" operators.

Yep. Perfectly legit. E.g. `WHERE 'Ali' IN (first_name,last_name)` — Strawberry, May 31 '16 at 15:37
Yes I tried and it worked fine, but how the database engine will distinguish between column names and string literals? I assume column names need proper escaping? — Sergey Danilchenko, May 31 '16 at 15:46
@symcbean `SELECT * FROM users WHERE 123 IN (id, parent)` should select user with id 123 and all his children. I think it's perfectly normal. — Sergey Danilchenko, May 31 '16 at 15:58
@SergeyDanilchenko: String literals are in *quotes*. Column names are *unquoted* (or wrapped in backticks `\``). — gen_Eric, May 31 '16 at 16:18

score 0 · Answer 1 · edited May 23 '17 at 10:29

0

Yes, you can - just as described in this question: Checking multiple columns for one value (sorry, can't flag question as duplicate, my flag count is over).

edited May 23 '17 at 10:29

Community

answered May 31 '16 at 15:38

Jehy

1 Answers1