PHP+MYSQL 字符串匹配查询

Question

数据表 
软件编号    软件名称    软件描述    适应的手机型号            下载次数 
1            soft1         描述         N73,N95,5300，E908           5 
2            soft2         描述         N73,N71,N75                  55 
2            soft2         描述         5320,5700,6110               85 查询条件$str_1="NokiaN73/2.0(07.00)profile/MIDP-2.0Configuration/CLD-1."; 我想根据$str_1中的N73查询数据表中“适应的手机型号”有N73的数据
结果： 
软件编号    软件名称    软件描述    适应的手机型号            下载次数 
1             soft1         描述          N73,N95,5300，E908          5 
2             soft2         描述          N73,N71,N75                 55 这样的SQL，怎么写？

Answer 1

mysql> select * from t_wwj860716;
+----------+----------+----------+-------------------+----------+
| 软件编号 | 软件名称 | 软件描述 | 适应的手机型号    | 下载次数 |
+----------+----------+----------+-------------------+----------+
|        1 | soft1    | 描述     | N73,N95,5300,E908 |        5 |
|        2 | soft2    | 描述     | N73,N71,N75       |       55 |
|        2 | soft2    | 描述     | 5320,5700,6110    |       85 |
+----------+----------+----------+-------------------+----------+
3 rows in set (0.00 sec)mysql>
mysql> set @str_1='NokiaN73/2.0(07.00)profile/MIDP-2.0Configuration/CLD-1.';
Query OK, 0 rows affected (0.00 sec)mysql> select * from t_wwj860716
    -> where @str_1 regexp replace(适应的手机型号,',','|');
+----------+----------+----------+-------------------+----------+
| 软件编号 | 软件名称 | 软件描述 | 适应的手机型号    | 下载次数 |
+----------+----------+----------+-------------------+----------+
|        1 | soft1    | 描述     | N73,N95,5300,E908 |        5 |
|        2 | soft2    | 描述     | N73,N71,N75       |       55 |
+----------+----------+----------+-------------------+----------+
2 rows in set (0.00 sec)mysql>
当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html