Home
Sign Up
Sign In
V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member
Sign In
›
正则表达式可视化调试 regex101.com
V2EX
›
正则表达式
求助:正则获取 sql 语句中的表名
CUPAIR
·
Dec 29, 2022
via Android · 1645 views
This topic created in 1225 days ago, the information mentioned may be changed or developed.
* 取出所有在 from 和 join 后面的表名
* 表名有单词字母.和_
* 目前写法:`const fromTable = lowerSql.match(new RegExp('\\b(from)\\b[\\s\\S]*?\\s+([\\w._]+)\\', "gi")) || []`
但 safari 不兼容零宽断言
表名
from
tch
RegExp
1 replies
1
wsWmsw
Jan 19, 2023 via Android
Safari 兼容前瞻不兼容后瞻断言吧
About
·
Help
·
Advertise
·
Blog
·
API
·
FAQ
·
Solana
·
5829 Online
Highest 6679
·
Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 47ms ·
UTC 02:42
·
PVG 10:42
·
LAX 19:42
·
JFK 22:42
♥ Do have faith in what you're doing.
❯