文章摘要
本文介绍了如何根据给定的关键字(如"js"、"javascript"、"c#"、"csharp"等)自动生成对应的SQL查询条件。文章通过`select case`语句,分别处理不同的关键字组合,确保在查询中正确匹配目标标题。每种情况下,SQL语句会检查标题是否包含指定的关键字,并通过`and`条件连接多个查询路径。对于其他关键字,文章则采用更简单的匹配方式。整体逻辑清晰,展示了如何通过条件语句实现精准的SQL查询生成。
select case lcase(keyarr(I))
case “js”
sqlk=sqlk&” and (title like ‘%”&keyarr(I)&”%’ or title like ‘%javascript%’)”
case “javascript”
sqlk=sqlk&” and (title like ‘%”&keyarr(I)&”%’ or title like ‘%js%’)”
case “c#”
sqlk=sqlk&” and (title like ‘%”&keyarr(I)&”%’ or title like ‘%csharp%’)”
case “csharp”
sqlk=sqlk&” and (title like ‘%”&keyarr(I)&”%’ or title like ‘%c#%’)”
case else
sqlk=sqlk&” and title like ‘%”&keyarr(I)&”%'”
end select
select case lcase(keyarr(I))
case “js”
sqlk=sqlk&” and (title like ‘%”&keyarr(I)&”%’ or title like ‘%javascript%’)”
case “javascript”
sqlk=sqlk&” and (title like ‘%”&keyarr(I)&”%’ or title like ‘%js%’)”
case “c#”
sqlk=sqlk&” and (title like ‘%”&keyarr(I)&”%’ or title like ‘%csharp%’)”
case “csharp”
sqlk=sqlk&” and (title like ‘%”&keyarr(I)&”%’ or title like ‘%c#%’)”
case else
sqlk=sqlk&” and title like ‘%”&keyarr(I)&”%'”
end select
© 版权声明
文章版权归作者所有,未经允许请勿转载。