mysql
过客看海
离开业务的技术没有意义,离开技术的业务没有底气
展开
-
mysql 按照指定顺序排序
SELECT `ID` FROM table_name WHERE `ID` in (1,2,3,4,5) ORDER BY FIELD(`ID`,5,4,3,1,2); // 纯数字字段不用处理引号,比较好拼接SELECT `ID` FROM table_name WHERE `ID` in (1,2,3,4,5) ORDER BY FIND_IN_SET(`post_title`,'A,B...原创 2019-06-26 15:17:45 · 3691 阅读 · 0 评论 -
mysql 修改字符串中部分数据
UPDATE mc_source SET dataJson = REPLACE(dataJson, '"needBalance":2', '"needBalance":1') WHERE orderNo = 'VIP100929029660090';原创 2019-07-04 15:45:50 · 1236 阅读 · 0 评论