模糊查询

最新推荐文章于 2024-10-05 00:24:42 发布

josnow

最新推荐文章于 2024-10-05 00:24:42 发布

阅读量265

点赞数

分类专栏： sql 文章标签： sql

本文链接：https://blog.csdn.net/josnow/article/details/72374749

版权

sql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

SET @ssxx = 1;
SET @lyid = null;
SET @fj = '%2%';
SET @jfzt =NULL;
SET @qyid = NULL;
SET @cbny =NULL;
SELECT sdfcb.id as id, sdfcb.cbny as cbny, fj.mc as ss, qy.mc as qy, ly.mc as ly, sdfcb.dbengyue as dby, sdfcb.dshangyue as dsy, sdfcb.dshiyong as dsy1, sdfcb.dzongzje as dzje,
               sdfcb.lsbenyue as lsby, sdfcb.lsshangyue as lssy, sdfcb.lsshiyong as lssy1, sdfcb.lshuizje as lszje,
               sdfcb.rsbenyue as rsby, sdfcb.rsshangyue as rssy, sdfcb.rshiyong as rssy1, sdfcb.rszje as rszje,
               sdfcb.dzongzje+sdfcb.lshuizje+sdfcb.rszje as yjje, sdfcb.jfzt as jfzt, sdfcb.jfsj as jfsj
               FROM t_xsgy_sdfcbxx sdfcb
                       LEFT JOIN t_baseinfo_fj fj ON fj.id = sdfcb.fjid
                       LEFT JOIN t_baseinfo_ly ly ON ly.id = fj.lyid
                       LEFT JOIN t_baseinfo_qy qy ON qy.id = ly.qyid
               WHERE sdfcb.ssxxid = @ssxx
                       AND (ly.id = @lyid or @lyid is null)
                       AND (qy.id = @qyid or @qyid is null)
                       AND (fj.mc like @fj or @fj is null)
                       AND (sdfcb.jfzt = @jfzt or @jfzt is null)

AND (sdfcb.cbny = @cbny or @cbny is null)

SET @fj = '%2%'; String = '%2%' String = 'Long'

SET @fj =%2% Long = String(如果String实际上为数可行，mysql特性，否则不行)