Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
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 "%(%(%" )
OR
( 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, ')')