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.
