sql - Filter in select where values start with NIR_ -

i trying filter result set return values start nir_.

my sql statement follows

select * run name %nir_%  

the result set includes names like

nirmeta_invalid nirmeta_position  

i not sure doing wrong. need select names start nir_.

you need escape underscore in like pattern if want treated literal.

in sql server:

select * run name 'nir[_]%' 

in mysql , oracle:

select * run name 'nir\_%'