For this reason a standard regexp does the job.

Nope. That reason is not enough on its own. It breaks on things like:

`fieldname` varchar(255) default 'Got you `haha haha`!',
[download]

Just because MySQL uses different quotes doesn't mean quotes cannot be contained inside other quotes.