In Wikipedia we often have article names with parenthesis like https://en.wikipedia.org/wiki/Walker_(surname) and it would be nice to have some function which enables me to find those, where the number of opening parenthesis matches the numer of closing ones.
Current solution is a query like
( pl_title LIKE "%)%)%" AND pl_title NOT LIKE "%(%(%" )
( pl_title LIKE "%)%" AND pl_title NOT LIKE "%(%" )
It would be a lot easier to write a query like
CHAR_COUNT(pl_title, '(') = CHAR_COUNT(pl_title, ')')