Does MySQL support a number or digit wildcard pattern?

Question

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?

Answer 1

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

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

Answer 2

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

will give you 1-9999999