db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael J. Segel" <mse...@segel.com>
Subject Re: Regular Expressions
Date Wed, 26 Oct 2005 16:18:07 GMT
On Wednesday 26 October 2005 09:20, duschhaube wrote:
> Hi!
> Is it possible to use regular expressions in a select statement.
> for example select * from test where name="a*b"
> ciao

Maybe its just your example, but what you're asking for is for all rows where 
the field name matches the string "a*b". That is, Name is a string.

Is that really what you are trying to do, or
did you mean can you prepare a statement like
"SELECT * FROM test WHERE name = ?"
then when you execute it, you pass in your variable...

Is that what you wanted?

Michael Segel
(312) 952-8175

View raw message