I have a list of names

1. Bobby
2. Owen
3. Lilly
4. Omar
5. Justin
6. Jamey
7. Oden

I would like to first get only the names that begin with 'o' so I wrote

WHERE name LIKE 'O%'

Which gave me

1. Owen
2. Omar
3. Oden

I would then like to add names that end with 'y'

1. Owen
2. Omar
3. Oden
4. Bobby
5. Lilly
6. Jamey

But I am having difficulty figuring out how to do so. I am working in oracle btw.

CodePudding user response：

Add the second condition after an OR:

WHERE name LIKE 'O%' OR name LIKE '%y'

CodePudding user response：

        SELECT * FROM MY_TABLE  WHERE name LIKE 'O%'
        UNION ALL
        SELECT * FROM MY_TABLE  WHERE name LIKE '%Y'

CodePudding user response：

You could also use the AND:

`WHERE name LIKE 'O%' AND name LIKE '%y'`