mysql ×Ö·û´®µÄ±È½Ï

Èç¹û±È½Ï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>