Split character for SQL query

xiaoxiao2021-03-06  108

Names = split (session ("city"), "|") i = 0

Conditions with multiple OR query statements

SQL = "Select * from qizu where field Like '%" & session ("field") & "%' and recrycle = 1 and (" for each name in namessql = SQL "City Like '%" & names (i) & "% 'or "i = i 1Nextsql = left (SQL, LEN (SQL) -4) &") Order By ID DESC

转载请注明原文地址:https://www.9cbs.com/read-102492.html

New Post(0)