56,677
社区成员
发帖
与我相关
我的任务
分享mysql 查询某字段内的7位数字
SELECT
*
FROM
`test`.`201611atk-6ne`
WHERE
CAST(
`test`.`201611atk-6ne`.`Tour Code` AS CHAR CHARACTER
SET utf8
) COLLATE utf8_general_ci REGEXP '^[0-9]{7}';
[Err] 2014 - Commands out of sync; you can't run this command now
把REGEXP换成LIKE 也提示2014错误
*
FROM
`test`.`201611atk-6ne`
WHERE
CAST(
`test`.`201611atk-6ne`.`Tour Code` AS CHAR CHARACTER
SET utf8
) COLLATE utf8_general_ci REGEXP '^[0-9]{7}';
[Err] 2014 - Commands out of sync; you can't run this command now
把REGEXP换成LIKE 也提示2014错误
...全文
请发表友善的回复…
发表回复
zjcxc 2017-03-16
- 打赏
- 举报
语法上看起来没错，你直接在 mysql 客户端中执行试试
weixin_37923491 2017-03-16
- 打赏
- 举报
有没有能简化的语句
rucypli 2017-03-16
- 打赏
- 举报
没错啊
mysql> SELECT
-> *
-> FROM
-> `test`.`201611atk-6ne`
-> WHERE
-> CAST(
-> `test`.`201611atk-6ne`.`Tour Code` AS CHAR CHARACTER
-> SET utf8
-> ) COLLATE utf8_general_ci REGEXP '^[0-9]{7}';
Empty set (0.07 sec)
mysql>
rucypli 2017-03-16
- 打赏
- 举报
命令行的那个客户端
weixin_37923491 2017-03-16
- 打赏
- 举报
请问您说的mysql是指哪个软件…我小白，目前在用navicat premium和 navicar of mysql
