如果比较Column_1 中的字符存在于Column_2
例如
Select 'A,B' AS Column_1 ,'B,C,D' AS Column_2
union
Select '12,45' AS Column_1 ,'B,123' AS Column_2
union
Select '12,45' AS Column_1 ,'B,123,45' AS Column_2;
我要的结果是
Select 'A,B' AS Column_1 ,'B,C,D' AS Column_2 ,1 AS result
union
Select '12,45' AS Column_1 ,'B,123' AS Column_2 ,0 AS result
union
Select '12,45' AS Column_1 ,'B,123,45' AS Column_2 ,1 AS result;
也就是说. Column_1只要有一个字符在Column_2 中, result 就为 1,否则为0
SQL code:
mysql> select *,
-> concat(',',Column_2,',') regexp concat(',(',replace(Column_1,',','|'),'),') AS result
-> from
-> (
-> Select 'A,B' AS Column_1 ,'B,C,D' AS Column_2
-> union
-> Select '12,45' AS Column_1 ,'B,123' AS Column_2
-> union
-> Select '12,45' AS Column_1 ,'B,123,45' AS Column_2
-> ) t;
+----------+----------+--------+
| Column_1 | Column_2 | result |
+----------+----------+--------+
| A,B | B,C,D | 1 |
| 12,45 | B,123 | 0 |
| 12,45 | B,123,45 | 1 |
+----------+----------+--------+
3 rows in set (0.00 sec)
mysql>
在安装Java编译器的Eclipse的时候，对环境变量进行了配置，在安装MySQl的时候也要对环境变量进行配置；那么后面的配置会影响前面的Eclipse的配置吗？
请大家多指教~！谢谢！
不会把，我这都装了的 我系统里 还装了 ......
