On Tue, 29 Jun 2004 15:13:10 -0400, wrote:
>zzapper:
>
>I could be reading it wrong, but it looks like you're looking for the
>result of your REGEXP in a list. REGEXP returns only a 0 or 1, not the
>expression resulting from performing a REGEXP.
>
>Wes
>
>On Jun 29, 2004, at 9:25 AM, zzapper wrote:
>
>> Hi,
>>
>> select * from ytbl_development as t1
>> where (t1.txtDevPostCode REGEXP
>> "^[[:alpha:]]{1,2}[[:digit:]]{1,2}[[:alpha:]]{0,1}" in
>> #QuotedValueList(qryRadius.shortpostcode)#)
>>
>> The above Where clause doesn't work , it just seems you can't use
>> REGEXP this way
>>
>> qryRadius.shortpostcode contains a list of "short" postcodes OX14
>> 1,OX14 2 etc
>>
>> whereas t1.postcode contains full postcodes OX14 5RA
>>
>> (If qryRadius.shortpostcode wasn't a list I'd be able to use LIKE)
>>
>> How can I write a Where clause that gets round this
Shawn,
Your solution doesn't work unfortunately because I need to operate on t1.postcode
before making the
comparison (IT'S USUALLY the OTHER WAY ROUND) , I think this must be a generic
problem, so I think
an eventual solution will be interesting
zzapper (vim, cygwin, wiki & zsh)
--
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]
