Need to write a SQL query to fetch data from a Oracle database [duplicate]

Question

Possible Duplicate:
Need to write a SQL query to fetch data from a Oracle database

I need to write a SQL query which can fetch a data from one table A.

Senario - Lets take table A has only two column C1 and C2. C1 has row_id's and C2 has vaues like "Site=google;site=gmail;yahoo"

Requirment - Need to write a query which can fetch all the row_id from column C1 of table A but the value should come for column C2 as "yahoo". Means if anything starts with "Site=" in any value of C2 column then it should not been shown in the data fetch.

Exact duplicate of "stackoverflow.com/questions/5091642/…"? — TToni
– TToni, Commented Feb 23, 2011 at 14:21
@TToni: I just re-read this and thought to myself that my SO hadn't refreshed properly lol — Neil Knight
– Neil Knight, Commented Feb 23, 2011 at 14:25

Jon Egerton · Accepted Answer · 2011-02-23 14:22:59Z

0

Try

select
   *
from
   tableA
where 
   c2 not like 'site=%'

answered Feb 23, 2011 at 14:22

Jon Egerton

41.8k11 gold badges100 silver badges130 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Neil Knight Over a year ago

I think you have misunderstood the question.

Vicky Over a year ago

No Jon, I think you got this wrong. Example - Suppose if a value is "Site=google;site=gmail;yahoo" then query should fetch "yahoo" only.

Jon Egerton Over a year ago

Ah, I see - give me a minute...

Jon Egerton Over a year ago

I see there's an answer on the other copy of this question. I'll leave it there.

Vicky Over a year ago

Jon that was different question..Here is different. If you can, then please answer it here. It would be great help.

Collectives™ on Stack Overflow

Need to write a SQL query to fetch data from a Oracle database [duplicate]

1 Answer 1

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Linked

Related