Q:

Does MySQL support a number or digit wildcard pattern?

I want to select titles that have a number after a certain character. Example:
SELECT * FROM table WHERE title LIKE '%- H(any number)'

How would I select any number in this statement 1-10000000 if the number exists?

A:

SELECT * FROM table WHERE title REGEXP '.*- H[0-9]+'

That seems like the kind of thing you're looking for.

A:

SELECT * FROM table WHERE title RLIKE '- H[:digit:]{1,7}$';

will give you 1-9999999

