Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
"
(aS)\s+((\`)?\w+(\`)?)(\s+|\,|(FRom\s+))
"
gmi
Input 1
SELECT a.WORKORDER_NO AS workOrderNo, a.ORD_TYPE AS ordType, a.ORD_NO AS ordNo, a.RETURN_FLAG AS returnFlag, a.AREA_ID AS areaId, a.USER_NAME AS userName, a.ADDR_DETAIL AS addrDetail, a.HANDLE_STAFF_ID AS handleStaffId, a.TAKE_STAFF_ID AS takeStaffId, a.TAKE_TS AS takeTs, a.RETURN_STAFF_ID AS returnStaffId, a.RETURN_TS AS returnTs, a.SUMMARY AS summary, a.WO_TITLE AS woTitle, a.INSTALL_FLAG AS installFlag, a.START_TS AS startTs, a.END_TS AS endTs, a.GRID_ID AS gridId, a.SCHEMA_ID AS schemaId, a.PROJECT_ID AS projectId, a.COMMENTS AS comments, a.STATE AS `state`, a.CREATE_USER AS createUser, a.CREATE_DATE AS createDate, a.MODIFY_USER AS modifyUser, a
Substitution
SELECT a.WORKORDER_NO AS workOrderNo, a.ORD_TYPE AS ordType, a.ORD_NO AS ordNo, a.RETURN_FLAG AS returnFlag, a.AREA_ID AS areaId, a.USER_NAME AS userName, a.ADDR_DETAIL AS addrDetail, a.HANDLE_STAFF_ID AS handleStaffId, a.TAKE_STAFF_ID AS takeStaffId, a.TAKE_TS AS takeTs, a.RETURN_STAFF_ID AS returnStaffId, a.RETURN_TS AS returnTs, a.SUMMARY AS summary, a.WO_TITLE AS woTitle, a.INSTALL_FLAG AS installFlag, a.START_TS AS startTs, a.END_TS AS endTs, a.GRID_ID AS gridId, a.SCHEMA_ID AS schemaId, a.PROJECT_ID AS projectId, a.COMMENTS AS comments, a.STATE AS `state`, a.CREATE_USER AS createUser, a.CREATE_DATE AS createDate, a.MODIFY_USER AS modifyUser, a