sql = "SELECT * FROM [表名] WHERE ddid LIKE '%,2,3'"
sql = sql & "OR ddid LIKE '%,3,2' OR ddid LIKE '2,%,3'"
sql = sql & "OR ddid LIKE '2,3,%' OR ddid LIKE '3,%,2'"
sql = sql & "OR ddid LIKE '3,2,%'"
我同意楼上的办法
不过那是循环来判断,就得从头到末尾的取出数据库中的记录加一判断,而你其实可以直接采用对SQL语言的操作来提高其效率
写在ASP中代码
<!--#include file="conn.asp"#-->
set conn=application("conn")
rs=server.createobject("adodb.recordcount")
sql = "SELECT * FROM [表名] WHERE ddid LIKE '%,2,3'"
sql = sql & "OR ddid LIKE '%,3,2' OR ddid LIKE '2,%,3'"
sql = sql & "OR ddid LIKE '2,3,%' OR ddid LIKE '3,%,2'"
sql = sql & "OR ddid LIKE '3,2,%'"
其实也不难实现
按照你上面说的
数据库中应该定义ddid的数据类型是字符型的
而且里面可能的数据是1,2,3 或者11,15,25等等这样的数据,那么你可以这样写你的SQL
sql = "SELECT * FROM [表名] WHERE ddid LIKE '%,2,3'"
sql = sql & "OR ddid LIKE '%,3,2' OR ddid LIKE '2,%,3'"
sql = sql & "OR ddid LIKE '2,3,%' OR ddid LIKE '3,%,2'"
sql = sql & "OR ddid LIKE '3,2,%'"