MySql and regular expressions

Question

Does anybody know how to either get a bit more detailed error message wrt MySql and regular expressions (i.e. the character position where the problem occurs) or if there is a tool that you can use to try out regular expressions without the need to trial and error with the database.

Answer 1

RegexBuddy can do this (and it's one of the few tools you can use to debug regexes in the MySQL-specific syntax).