Warm tip: This article is reproduced from stackoverflow.com, please click
oracle wildcard

WILDCARDS in SQL Oracle

发布于 2020-04-03 23:43:18

I am trying to find all the name that starts with either A,B or C in Oracle DB and I wrote this syntax:

SELECT NUME FROM JUCATORI
WHERE NUME LIKE '[ABC]%';

but it doesn't not give me any name (neither error), even though I am sure I have in my DB names that starts with either A,B or C.

Questioner
Bianca
Viewed
96
Littlefoot 2020-01-31 20:27

One option is

where substr(nume, 1, 1) in ('A', 'B', 'C')