忽略IN的类型转换 [英] Ignore type casting IN

问题描述

我有问题.

mysql> SELECT 0 IN ('a',4);
+--------------+
| 0 IN ('a',4) |
+--------------+
|            1 |
+--------------+
1 row in set, 1 warning (0.00 sec)

mysql> SELECT 1 IN ('a',4);
+--------------+
| 1 IN ('a',4) |
+--------------+
|            0 |
+--------------+
1 row in set, 1 warning (0.00 sec)

'a'强制转换为0.如何使'a'未被强制转换..?

'a' casting to 0.How to make that 'a' not been casting..?

推荐答案

将要比较的值转换为字符串:

Convert the value you're comparing to a string:

mysql> SELECT '0' IN ('a', '4');
+-----------------+
| '0' IN ('a', 4) |
+-----------------+
|               0 |
+-----------------+

mysql> SELECT '4' IN ('a', '4');
+-----------------+
| '4' IN ('a', 4) |
+-----------------+
|               1 |
+-----------------+

这篇关于忽略IN的类型转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！