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
/
\B:(?!\d+\b)\w+
/
gm
Input 1
1
SELECT name, horse, id, DATE_FORMAT(Nee.datetimed, '12:12:12 @ %D') as del_time FROM members WHERE biztype LIKE CONCAT('%',:bizb,'%') AND (locate LIKE '%hos%' OR locate LIKE '%all%') AND bizcat LIKE CONCAT('%',:catb7,'%') ORDER BY `status` DESC, RAND() Valid catches: :adbcd :5fedg :56_gt :der :9_6 INVALID catches: :12 :1 :%D [MySQL date formatting]
Substitution
SELECT name, horse, id, DATE_FORMAT(Nee.datetimed, '12:12:12 @ %D') as del_time FROM members WHERE biztype LIKE CONCAT('%',:bizb,'%') AND (locate LIKE '%hos%' OR locate LIKE '%all%') AND bizcat LIKE CONCAT('%',:catb7,'%') ORDER BY `status` DESC, RAND() Valid catches: :adbcd :5fedg :56_gt :der :9_6 INVALID catches: :12 :1 :%D [MySQL date formatting]