REGEX-Escape for:
INSERT INTO 'users' ('name','username','email','password','role') VALUES (?,?,?,?,?)

Your Input:

Ads

Result, the escaped string:

INSERT INTO 'users' \('name','username','email','password','role'\) VALUES \(\?,\?,\?,\?,\?\)

Ads

What must the escaping look like for:
INSERT INTO 'users' ('name','username','email','password','role') VALUES (?,?,?,?,?)

The escaped text for use in a regex is:

INSERT INTO 'users' \('name','username','email','password','role'\) VALUES \(\?,\?,\?,\?,\?\)


Ads