How to use single character instead of wildcard

Question

i can't find solution on internet of that problem, everything what i got is connected with wildcard, and i don't wanna to use wildcard in my case

i want to find all tables that have ending '_N' so im trying to execute something like that

select * from dba_tables v
where v.table_name like '%_N';

but '' wildcard means that search all tables with name [can be everything][need to be some character]N i just want to use that '' i want to have all tables with '_N' ending, so for example tables like 'EXAMPLE_N' 'HELP_ME_N'.

How can i not use '_' wildcard?

Possible duplicate of [Escape underscore in PL/SQL](https://stackoverflow.com/questions/34199531/escape-underscore-in-pl-sql) — Cee McSharpface, Nov 23 '18 at 15:38
Possible duplicate of https://stackoverflow.com/q/21380261/1132334 — Cee McSharpface, Nov 23 '18 at 15:39
sorry you were right, i was trying "how to not use wildcards" etc. and only result i had was threads about wildcards. Thanks! — Potato, Nov 23 '18 at 15:52

score 0 · Accepted Answer · answered Nov 23 '18 at 15:37

0

You can use escape:

where v.table_name like '%$_N' escape $

The default escape character is \:

where v.table_name like '%\_N';

That works as well.

answered Nov 23 '18 at 15:37

Gordon Linoff

1,242,037
58
646
786

Don't know, but I'd guess because answers to obvious dupes are often punished ¯\_(ツ)_/¯ – Dave Newton Nov 25 '18 at 05:07

ScaisEdge · Answer 2 · 2018-11-23T17:04:29.300

0

You could escape '_' using \

select * from table  
where table_name.column_name like '%\_N';

edited Nov 23 '18 at 17:04

answered Nov 23 '18 at 15:38

ScaisEdge

131,976
10
91
107

Don't know, but I'd guess because answers to obvious dupes are often punished ¯\_(ツ)_/¯ – Dave Newton Nov 25 '18 at 05:08

score 0 · Answer 3 · answered Nov 23 '18 at 18:13

0

you can also use this:

select * from dba_tables v
where regexp_like(v.table_name,'.*_N$');

answered Nov 23 '18 at 18:13

Nikhil S

3,786
4
18
32

How to use single character instead of wildcard

3 Answers3