sql

select b.id, a.id,a.question as q, b.question as qs, a.answer from ybzkb.qa a left join ybzkb.qa_similar b on a.id=b.qid where b.question like '%税%' group by b.id order by a.id

QA数据清理

• select * from yycloudkb.qa;

• select * from yycloudkb.qa where question is null or question='';

• delete from yycloudkb.qa where question is null or question='';

• select * from yycloudkb.qa_similar where question is null or question='';

• delete from yycloudkb.qa_similar where question is null or question='';

• select * from yycloudkb.qa_similar where (qid not in (select id from yycloudkb.qa)) or (qid is null) or (qid='');

• delete from yycloudkb.qa_similar where (qid not in (select id from yycloudkb.qa)) or (qid is null) or (qid='');

• select b.id, a.id as q_id, b.qid,a.question as q, b.question as qs, a.answer, a.createTime from yycloudkb.qa_similar b left join yycloudkb.qa a on a.id=b.qid where b.question like '%%' group by b.id order by a.createTime desc