bug in SELECT WHERE LIKE

[Chris Huber]

Is there a known bug for range selection using LIKE in MySQL 5.0.15? When I try:

SELECT result FROM varchar_col WHERE result LIKE '1';

I get all the rows with '1'. When I try:

SELECT result FROM varchar_col WHERE result LIKE '[0-9]';

I get no results.

Please advise.