比较简单直接的sql语句
Recordset1.Source = SELECT * FROM 表 WHERE 字段 LIKE '% + Replace(Recordset1__MMColParam, ', '') + %' or 字段2 like '% + Replace(Recordset1__MMColParam, ', '') + %' ORDER BY id DESC
Recordset1.Source = SELECT * FROM 表 WHERE 字段 LIKE '% + Repl
代码如下: $sql=$empire->query(“select table.title,lianxi,table.dizhi,table.id from table,table1 where table1.sid like concat( ‘%|’,table.id,’|%’) and table1.id=”.$navinfor[id].””); while($r=$empire->fetch($sql)) { $title=$r[‘title’]; $lianxi=$r[‘li