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
See Question&Answers more detail:os