SUBSTRING_INDEX

SUBSTRING_INDEX精品文章

• 

  开发文档

  ...nd b.bo_machineroom =a.bo_machineroom) LEFT JOIN (SELECT b.bo_arae, substring_index(b.bo_machineroom,/,2 ) as louchen,COUNT(1) as lounum FROM zq_ho_board b where b.bo_camtype=#{camtype} GR...

  张巨伟 2019-08-16 10:41 评论0 收藏0
• 

  得到每个分组里的最大最小记录 Mongo VS Mysql

  ...1024还不够用 SET SESSION group_concat_max_len = 20480; select state, substring_index(group_concat(city order by pop ),,,1) smallestCity, min(pop),substring_index(group_concat(city order by pop ),,,-1)...

  gekylin 2019-06-26 17:16 评论0 收藏0
• 

  MySQL 查询in操作，查询结果按in集合顺序显示

  MySQL 查询in操作，查询结果按in集合顺序显示 复制代码 代码如下: select * from test where id in(3,1,5) order by find_in_set(id,3,1,5); select * from test where id in(3,1,5) order by substring_index(3,1,2,id,1);

  LancerComet 2019-07-01 12:35 评论0 收藏0