OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Urgent!

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Urgent! [message #61856]

Mon, 07 June 2004 01:11

Sheila
Messages: 28
Registered: May 1998

Junior Member

I need to select rows from a table that contains a substring.
for example, the column contains the follwoing values:

col_name
---------------
LoggedOn - 1.3.4.5
LoggedOff - 1.4.5.0
LoggedOn - 1.3.5.2

I need to select rows which contain 'loggedOn' value (I mean the first and the last one).

Any idea is appreciated

Report message to a moderator

Re: Urgent! [message #61857 is a reply to message #61856]

Mon, 07 June 2004 01:53

Maaher
Messages: 7065
Registered: December 2001

Senior Member

SELECT *
  FROM yourtable
 WHERE col_name LIKE 'LoggedOn%';

is one way to do this.

MHE

Report message to a moderator

Re: Urgent! [message #61863 is a reply to message #61856]

Mon, 07 June 2004 02:27

Deepak Panda
Messages: 24
Registered: May 2004

Junior Member

select * from

where col_name like '%LoggedOn%';

Hope this works

Report message to a moderator

Re: Urgent! [message #61864 is a reply to message #61857]

Mon, 07 June 2004 03:21

neemic
Messages: 4
Registered: May 2004

Junior Member

or -
select * from your_tab
where substr(your_col,1,8) = 'LoggedOn'

Regards,
neemic

Report message to a moderator

Previous Topic:	EM becomes disable when I create foreign keys!
Next Topic:	Help please.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:31:42 CDT 2024