Does MySQL have a wilcard number?

Question

I want to select headers that have a number after a specific character. Example:

SELECT * FROM table WHERE title LIKE '%- H(any number)' 

How can I select any number in this expression 1-10000000 if the number exists?

Answer 1

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

This is similar to what you are looking for.

Answer 2

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

will provide you 1-9999999

Answer 3

Use regex :

 SELECT ... FROM table WHERE title REGEXP '- H([1-9][0-9]{0,6}|10000000)$' ;