mysql - How to get records which contain alphaNumeric characters + white-spaces

Question

How to get records which contain alphaNumeric characters + white-spaces. OR At-list single numeric character in name.

i.e spiderman 1, abc12 part1

What I have done.:

 select * from table t where t.name REGEXP '^[A-Za-z0-9]+$' 

but it will gives only records which dont have white space : i.e abc123

so I also tried

  select * from table t where t.name REGEXP '^[A-Za-z0-9 ]+$' 

Now, it gives me some records which does not contain any numeric characters. i.e abcdefg hij

Answer 1

SELECT *
FROM table
WHERE name REGEXP '^[a-zA-Z0-9 ]+$' AND name REGEXP '[0-9]'

Simpler:

SELECT *
FROM table
WHERE name REGEXP '^[a-zA-Z0-9 ]*[0-9][a-zA-Z0-9 ]*$'