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|^starts like this|ends like this$|it
contains.*something.*like.*this"
and on and on...
Kelley
zzapper wrote:
> 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 of REGEXP doesnt exist AFAIK , what work arounds exist, or
> how would you do it?
>
> BTW the QuotedValueList contains "Short Postcodes of type AA11 or A11
> or AA1
>
> zzapper
> --
>
> vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?"
>
> http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
