Sublime Text 正则表达式

示例:
INSERT INTO `` VALUES ('0000451e-b917-3a8e-e8fc-6a17b95d5465', '1', '2', '3');
INSERT INTO `` VALUES ('00005e67-fcaf-6a57-2e01-aaaee3efc527', '4', '5', '6');
INSERT INTO `` VALUES ('00012412-6021-e41f-34e3-d93fcc419dcb', '7', '8', '9');




正则表达式:
(^INSERT .+ \()('\S+'), ('\S+'), ('\S+'), ('\S+')\)

UPDATE `t_cert` SET user_cert1=$3, user_cert2=$4, user_cert3=$5 WHERE uid = $2
 
示例二:
<546>is <225>this <213>really <144>ture
正则表达式:
<\d+>

示例:
[01:15.95]이럼 안되는데 안될거 아는데
正则表达式:
\[+\d+\:+\d+\.+\d+]+\S+(.*)
 
示例:
  	9936	+
正则表达式:
  	+\d+	+\+
 
示例:
UPDATE `` SET `full_name` = '卓越工坊(北京)科技有限公司', `company_id` = 10354, `company_status` = 1, `company_type` = 10, `c_start_time` = '2022-02-22 00:00:00', `c_end_time` = '2023-02-22 23:59:59', `poi_id` = 905335 [i][b]WHERE `full_name` = '卓越工坊(北京)科技有限公司' AND `company_id` = 10354 AND `company_status` = 1 AND `company_type` = 10 AND `c_start_time` = Cast('2022-02-22 00:00:00' AS Binary(19)) AND `c_end_time` = Cast('2023-02-22 23:59:59' AS Binary(19)) AND[/b][/i] `poi_id` = 905335 LIMIT 1;

 
表达式:
WHERE.+`\s.+AND 

0 个评论

要回复文章请先登录注册