Home » SQL & PL/SQL » SQL & PL/SQL » inserting regular expression in SQL Table.
inserting regular expression in SQL Table. [message #221322] Mon, 26 February 2007 05:09 Go to next message
satish@123
Messages: 15
Registered: February 2006
Junior Member
hi,

please tell me is there any way to insert a regular expression into a table.

table1
=====================
column1 column2
=====================
ha* 10

For ex : if i write a query like select * from table1 where column1 like 'hai'; it should display ha* 10.

Re: inserting regular expression in SQL Table. [message #221390 is a reply to message #221322] Mon, 26 February 2007 09:41 Go to previous messageGo to next message
srinivnp
Messages: 136
Registered: January 2006
Location: stlouis MO USA
Senior Member


Why do you want to do that ?

Srini
Re: inserting regular expression in SQL Table. [message #221396 is a reply to message #221390] Mon, 26 February 2007 09:56 Go to previous messageGo to next message
satish@123
Messages: 15
Registered: February 2006
Junior Member
hi,

I need to retrieve the data as i mentioned in the previous query from the given example table.

Is there any way to retrieve like that

thanks,
satish
Re: inserting regular expression in SQL Table. [message #221548 is a reply to message #221322] Tue, 27 February 2007 07:15 Go to previous message
Buchas
Messages: 83
Registered: March 2006
Member
Why don't you try
select * from table1 where column1 like 'ha%';
or
select * from table1 where column1 like 'ha_';
?

[Updated on: Tue, 27 February 2007 07:17]

Report message to a moderator

Previous Topic: Where to go from here?
Next Topic: java stored procedure with ref cursor
Goto Forum:
  


Current Time: Wed Dec 07 12:26:47 CST 2016

Total time taken to generate the page: 0.05752 seconds