MYSQL 查询一个表多个字段时 查询结果怎么指定某个字段匹配到的数据显示在前面？

[白猫猫]

比如模糊搜索a b c三个字段，怎么让a字段有关建字的显示在前面 b c字段的排在后面

[二月十六]

SELECT * FROM 表 ORDER BY a

[仰视的菜鸡]

select * from 表 where like 字段名='a,b,c' order by a desc

[小白619]

select a,b,c from 表？

[学海无涯-回头是岸]

SELECT A,B,C FROM T1 ORDER BY A DESC

[startgetnow]

根据你的意思应该是把b,c字段的数据优先显示，a显示在最后：
第一步：根据条件查询出数据
select * from table where b like '%value%' or c like '%value%' or a like '%value%'
第二步：遍历查询结果
将b,c的数据放入第一个数组，a的数据放入第二个数组，最后再将两个数组拼接起来即可。

[RINK_1]

select * from 
(select *,0 as rn from table where a like '%关键字%'
union 
select *,1 as rn from table where b like '%关键字%'
union
select *,1 as rn from table where c like '%关键字%') as A
order by rn 

[吉普赛的歌]

drop table if exists t;
CREATE table t(
a varchar(20),
b varchar(20),
c varchar(20)
);
INSERT into t values('ffee','bbzeb','123');
INSERT into t values('ddee','bbaeb','1234');
INSERT into t values('kkn','bbfaeb','1235');
INSERT into t values('kkn','bbgaeb','1235');
INSERT into t values('kkn','bbgaeb','12935');

select * from t 
where a like '%d%'
or b like '%z%'
or c like '%9%'
ORDER BY
CASE when a like '%d%' then 0
when b like '%z%' then 1
else 2 end
;