Regular Expressions 101

Explanation
Pro

\Bnot an ASCII word boundary

%sthe literal text %s (case sensitive)

\ban ASCII word boundary

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

Detailed match information will be displayed here automatically.

25 tokens

\B%s\b

select * from users where id=%s and email LIKE '%sayhello%' '%s'
%s 
if it end%s up in a sentence, it won't break
Te%st

select * from users where id=%s and email LIKE '%sayhello%' '%s'
%s 
if it end%s up in a sentence, it won't break
Te%st