1.用于模糊查询，做为过滤条件

---------------------------上级的新闻下级可以看到-------------------------
SELECT a.pk_cms_nrgl_st AS pk_id, a.time_stamp AS time_stamp, b.xalljgmc AS xalljgmc, a.cbt AS cbt, a.fk_cms_lmgl AS fk_cms_lmgl, a.cfbsj AS cfbsj, a.czt AS czt, a.cbody AS cbody, a.sys_xzqh AS sys_xzqh, a.sys_djzt AS sys_djzt, a.sys_djztms AS sys_djztms, a.sys_spzt AS sys_spzt, a.sys_spzt AS sys_spztmc, a.sys_spztms AS sys_spztms, a.sys_shrid AS sys_shrid, a.sys_shr AS sys_shr, a.sys_shrq AS sys_shrq, a.sys_xgrid AS sys_xgrid, a.sys_xgr AS sys_xgr, a.sys_xgrq AS sys_xgrq, a.sys_zdrid AS sys_zdrid, a.sys_zdr AS sys_zdr, a.sys_zdrq AS sys_zdrq FROM cms_nrgl_st a, mz_xzjg b WHERE a.sys_xzqh=b.xzqh_id AND a.sys_scbj = '0' AND INSTR('330101', b.node_id) > 0 AND a.sys_spzt = 1 ORDER BY time_stamp desc, cfbsj desc limit 0, 20

配置

<where name="user.xnode"  code="b.node_id"  datatype="string" attribute="true" scope="session" opersign="instrcode" link="AND" />

2.以下代码等同上面的，用了concat做拼接

SELECT a.pk_cms_nrgl_st AS pk_id, a.time_stamp AS time_stamp, b.xalljgmc AS xalljgmc, a.cbt AS cbt, a.fk_cms_lmgl AS fk_cms_lmgl, a.cfbsj AS cfbsj, a.czt AS czt, a.cbody AS cbody, a.sys_xzqh AS sys_xzqh, a.sys_djzt AS sys_djzt, a.sys_djztms AS sys_djztms, a.sys_spzt AS sys_spzt, a.sys_spzt AS sys_spztmc, a.sys_spztms AS sys_spztms, a.sys_shrid AS sys_shrid, a.sys_shr AS sys_shr, a.sys_shrq AS sys_shrq, a.sys_xgrid AS sys_xgrid, a.sys_xgr AS sys_xgr, a.sys_xgrq AS sys_xgrq, a.sys_zdrid AS sys_zdrid, a.sys_zdr AS sys_zdr, a.sys_zdrq AS sys_zdrq FROM cms_nrgl_st a, mz_xzjg b WHERE a.sys_xzqh=b.xzqh_id AND a.sys_scbj = '0' and a.sys_spzt = 1
AND '33' LIKE concat(b.node_id,'%') ORDER BY time_stamp desc, cfbsj desc limit 0, 20

最新文章

  1. node.js
  2. SharePoint 2010 GridView/SPGridView完全应用系统样式
  3. php 301 重定向 转自http://www.icoa.cn/a/475.html
  4. Linux下对比两个文件夹的方法
  5. C#Light/Evil合体啦
  6. ASP.NET MVC3 在_ViewStart設定Layout後用RenderAction的注意事項
  7. [转]IE11下Forms身份认证无法保存Cookie的问题
  8. 配置Git Extension免密码发布代码到CSDN
  9. android selector
  10. Codeforces Educational Codeforces Round 3 D. Gadgets for dollars and pounds 二分，贪心
  11. openerp学习笔记 webkit 打印
  12. PC和ARM平台编译Qt的命令
  13. python之路--day6---文件处理
  14. kill -9 ，kill -12，kill -15
  15. data science学习笔记1
  16. BFC清除浮动
  17. 第一个程序HelloWorld及常见问题解决和练习
  18. bootstrap切换按钮点击后显示的颜色
  19. ContextMune上下文菜单中，二级菜单获取及状态设置
  20. SQL 条件 判断 select case as

热门文章

  1. ImportError: DLL load failed with error code -1073741795
  2. Django---Django返回用户输入数据
  3. gulp常用插件之gulp-useref使用
  4. JavaDay9(上)
  5. HDU5608
  6. H5-安卓和ios调用相机和相册
  7. java 8 supplier object区别
  8. linux学习之编译-链接
  9. JQ input输入框回车生成标签，可删除，并获取标签的值
  10. KVM命令--使用篇（1）