求一个匹配SQL语句的正则

2006-08-20 11:05:46 357 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

【华为2021校招】笔试题【通用硬件】时间：2020/07/15 19:00 时长：60min 题型：40单选+5多选难度：中等考察范围：模电、数电、SI、EMC、电源、微机原理、计算机网络、材料阅读详情

匹配所有的sql语句，要求提取出select，from，where三个部分，order和group部分不要
select a.*,b.* from aaa a left join bbb b on a.id=b.id where a.id=33 group by a.id order by b.id
类似这样的语句，要求提取出 a.*,b.* 和 aaa a left join bbb b on a.id=b.id where a.id=33

...全文

博流BL602开发二环境搭建与固件烧录实战本文详细介绍了博流BL602 RISC-V芯片开发环境的搭建与固件烧录全流程。从Linux/WSL系统选择、RISC-V工具链配置、SDK获取，到编译首个Wi-Fi示例并生成固件镜像，再到通过命令行或图形化工具完成烧录及串口测试，提供了完整的实战指南和常见问题解决方案。阅读详情

king2world

基础编程 21,889 成员 140,329 内容

+ 关注 + 加入社区

切换为时间正序

helloyou0 2006-08-20

打赏
举报

需要处理子查询吗？

SysTem128 2006-08-20

打赏
举报

<?php
$Str="select a.*,b.* from aaa a left join bbb b on a.id=b.id where x=\"xasdfas select saflsafj from asfsaf where x=\"xasdfas select saflsafj from asfsaf where x=\"xasdfas select saflsafj from asfsaf where safasf\"\" safasf\" a.id=33 group by a.id order by b.id ";
print preg_replace("/select(.+?)from(.+?)where(.*?)(order|group)/","Se: $1 Fro: $2 Whe $3 ",$Str);
?>结果：
---------------
Se: a.*,b.*
Fro: aaa a left join bbb b on a.id=b.id
Whe x="xasdfas select saflsafj from asfsaf where x="xasdfas select saflsafj from asfsaf where x="xasdfas select saflsafj from asfsaf where safasf"" safasf" a.id=33

by b.id group by a.id
---------------
可包含无限子查询
换成
'order by b.id group by a.id'
'group by a.id order by b.id'
都没问题但~~
哪位高手给看看,我搞了半天'by b.id group by a.id'也没去掉.

king2world 2006-08-20

打赏
举报

这样不行，详细说一下吧，现在语句的可能性有
select .... from .....
select .... from .... order by ...
select .... from .... group by ... order by ...
select .... from .... where ....
select .... from .... where .... order by ...
select .... from .... where .... group by ... order by ...
主要的就是这些了吧，就是order by ... 部分不要　group by ...部分不要然后有where的，join的都包含到第二部分里边 select的部分算第一部分

helloyou0 2006-08-20

打赏
举报

嘿嘿，要考虑这种情况：
select * from aaa where x="xasdfas select saflsafj from asfsaf where safasf";

SysTem128 2006-08-20

打赏
举报

<?php
$Str="select a.*,b.* from aaa a left join bbb b on a.id=b.id where a.id=33 group by a.id order by b.id";
echo preg_replace("/select (.+?) from (.+?) where (.+?) /i","$1 $2 $3 ",$Str);
?>

没搞清你要干什么~~
乱写个先……

king2world 2006-08-20

打赏
举报

不需要，子查询不用管

求一个匹配SQL语句的正则

相关推荐