1.使用GROUP BY 分组 加HAVING条件
(因为where关键字无法与合计函数一起使用,例如sum(),avg()等,所以当有条件的话,需要放在having下)
下面展示一些 内联代码片
。
// An highlighted block
SELECT
v.id,
v.video_name,
CONCAT(v.video_hour,':',v.video_minutes,':' ,v.video_seconds) videolength,
v.video_hour,
v.video_minutes,
v.video_seconds,
v.video_cover,
v.video_id,
v.video_type,
v.is_del,
v.create_date,
GROUP_CONCAT(c.`name`) courseNames,
c.id
FROM
t_video v
LEFT JOIN t_course_section s ON v.id = s.video_id
LEFT JOIN t_course c ON s.parent_id = c.id
where c.id = '54fad60a37d94773abca4c42fdf7fd81'
GROUP BY v.id HAVING courseNames like '%模糊搜索词%'