多表 多字段模糊查询 一个查询 匹配作者名或帖子名 或论坛名 这个改怎么实现 不使用es的情况下 sql怎么实现
3条回答 默认 最新
- 嘉祐-小萝卜算子 2022-04-03 12:37关注
SELECT
a.id AS "id",
a.forum_id AS "forumId",
a.title AS "tzTitle", //想要模糊查询的字段
a.content AS "content",
a.author_id AS "authorId",
a.create_by AS "createBy.id",
a.create_date AS "createDate",
a.update_by AS "updateBy.id",
a.update_date AS "updateDate",
a.del_flag AS "delFlag",
a.dznum AS "dznum",
a.plnum AS "plnum",
a.boutique AS "boutique",
u.NAME AS "authorName", //想要查询的字段
a.bq_id AS "bqId",
b.NAME AS "bqName",
t.title AS "talktitle", //想要模糊查询的字段
a.talk_id AS "talkId",
u.photo AS "photo",
f.title AS "title",
a.scnum AS "scnum",
f.tznum AS "tznum",
d.dz_num AS "zzdznum",
d.ft_num AS "zzftnum",
u.company_id AS "companyid",
a.posttype AS "postType"
FROM
lt_posts a
LEFT JOIN sys_user u ON u.id = a.author_id
LEFT JOIN lt_bq b ON b.id = a.bq_id
LEFT JOIN lt_talk t ON t.id = a.talk_id
LEFT JOIN lt_forum f ON f.id = a.forum_id
LEFT JOIN lt_author_dsg d ON d.author_id = a.author_id
WHERE
a.del_flag = 0
AND a.posttype = '2'
AND a.forum_id = “1"
And (a.title like concat(‘%’,#{keywords},’%’) or u.name like concat(‘%’,#{keywords},’%’) or t.title like concat(‘%’,#{keywords},’%’) )
ORDER BY
a.update_date DESC
LIMIT 5本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 1无用
悬赏问题
- ¥15 网络科学导论,网络控制
- ¥15 metadata提取的PDF元数据,如何转换为一个Excel
- ¥15 关于arduino编程toCharArray()函数的使用
- ¥100 vc++混合CEF采用CLR方式编译报错
- ¥15 coze 的插件输入飞书多维表格 app_token 后一直显示错误,如何解决?
- ¥15 vite+vue3+plyr播放本地public文件夹下视频无法加载
- ¥15 c#逐行读取txt文本,但是每一行里面数据之间空格数量不同
- ¥50 如何openEuler 22.03上安装配置drbd
- ¥20 ING91680C BLE5.3 芯片怎么实现串口收发数据
- ¥15 无线连接树莓派,无法执行update,如何解决?(相关搜索:软件下载)