Regular Expressions _# at end of string

Question

I am using the REGEXP_LIKE function in Oracle 10g to find values in a column with a suffix of _#(like _1, _2 etc). I can find _# in any part of the value with the query below but can I return only values with _# at the end ?

SELECT * FROM Table WHERE  REGEXP_LIKE (COLUMN,'_[[:digit:]]')

Answer 1

Sure. Use...

SELECT * FROM Table WHERE  REGEXP_LIKE (COLUMN,'_[[:digit:]]$')

The $ character matches "the end of the string."

Answer 2

No need to use reg exps.

select * from table where substr(column,-2) between '_0' and '_9';