select * from
(SELECT * FROM `article` where 1=1 and keywords REGEXP '长江|品种|qq' ORDER BY time desc) aa
UNION all
select * from
(SELECT * FROM `article` where 1=1 and keywords not REGEXP '长江|品种|qq' ORDER BY time desc ) tt
;
select * from
(SELECT * FROM `article` where 1=1 and keywords REGEXP '长江|品种|qq' ORDER BY time desc) aa
UNION all
select * from
(SELECT * FROM `article` where 1=1 and keywords not REGEXP '长江|品种|qq' ORDER BY time desc ) tt
;