标题包含关键字 ①、比较粗糙的匹配,可能不太精确:ilelike%$avifo[keyboad]% ②、精确的匹配,比较消耗资源:ile
标题包含关键字
①、比较粗糙的匹配,可能不太精确:
title like '%$navinfor[keyboard]%'
②、精确的匹配,比较消耗资源:
title regexp '(^|,)$navinfor[keyboard]($|,)'
关键字相同
①、比较粗糙的匹配,可能不太精确:
keyboard like '%$navinfor[keyboard]%'
②、精确的匹配,比较消耗资源:
keyboard regexp '(^|,)$navinfor[keyboard]($|,)'
格式1:
①、模糊匹配
[e:loop={"select * from phome_ecms_news where title like '%$navinfor[keyboard]%' or keyboard like '%$navinfor[keyboard]%' order by id desc limit 10",0,24,0}] [/e:loop]
②、精确的匹配
[e:loop={"select * from phome_ecms_news where title regexp '(^|,)$navinfor[keyboard]($|,)' or keyboard regexp '(^|,)$navinfor[keyboard]($|,)' order by id desc limit 10",0,24,0}] [/e:loop]
格式2:
①、模糊匹配
[e:loop={'news',10,3,0,"keyboard like '%$navinfor[keyboard]%' or title like '%$navinfor[keyboard]%'",''}] [/e:loop]
或
[e:loop={0,10,3,0,"keyboard like '%$navinfor[keyboard]%' or title like '%$navinfor[keyboard]%'",''}] [/e:loop]
注意:在没有相关文章时,会调用最新的文章来替代空缺的位置
本网刊登的文章均仅代表作者个人观点,并不代表本网立场。文中的论述和观点,敬请读者注意判断。
2021-02-27
2022-04-12
2022-05-30
2022-05-29
2021-03-20
2021-08-29
2021-08-27
2021-02-08