What is th wildcard for any digit? Tried searching online but only found the below wildcards. Is their any wildcard like "#" that is used in MS Access. Trying to find string characters that contain digits like:

"SnapMirror[22]" would be a valid return row.


_ (underscore) = Any single character (SQL)
% = Any string of zero or more characters (SQL)


Thanks everyone for your advice and comments

btw, i'm using mysql 4.1.12a-nt

...WHERE column_name REGEXP '[0-9]*'

http://dev.mysql.com/doc/refman/5.0/...-matching.html

Whoops, that's what I get for copying straight off of the mysql site. The * operator will match 0 or more occurences, and you don't want that. So just remove the *.

Thanks for the help!