On Sun, 19 Oct 2003 22:08:30 -0400, Kelley Lingerfelt
<[EMAIL PROTECTED]> wrote:
>
>WHERE lookup RLIKE "this|that|other|^starts like this|ends like this$|it
>contains.*something.*like.*this"
>
I am not yet expert enough in mySQL to even specify my question
accurately (so I will have another go)
I'm not sure what you're using to query with, but with the REGEXP expression
you can OR(|) regular expression out the wazoo, so the capablility is built
in MySQL.
and I would consider it to be a pretty straightforward solution, you can do
something like
WHERE lookup RLIKE "this|that|other|^start
Hi
I can write a query such
where left(t1.txtDevPostCode,5) in
(#QuotedValueList(qryRadius.postcode)#)
but unfortunately UK postcodes are variable length
SO I really want something like
where REGEXP(t1.txtDevPostCode,"^[a-z]{1,2}[0-9]0,2}") in
(#QuotedValueList(qryRadius.postcode)#)
This use