db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From duschhaube <duschha...@gmx.net>
Subject Re: Regular Expressions
Date Thu, 27 Oct 2005 06:25:38 GMT
Michael J. Segel wrote:

>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?
>  
>
If I use the prepare statement, i have to create the variables by my 
self. this is not realy what I need. but I think 'like' is what i'm 
looking for.
select * from test where name like 'a%b'

this is exactly what I need.



Mime
View raw message