List:General Discussion« Previous MessageNext Message »
From:Larry Martell Date:January 7 2014 7:43pm
Subject:Re: regexp in conditional
View as plain text  
On Tue, Jan 7, 2014 at 12:31 PM, Peter Brawley
<peter.brawley@stripped> wrote:
>
> On 2014-01-07 1:22 PM, Larry Martell wrote:
>>
>> Can I use an regexp in a conditional? I need to do something like this:
>>
>> SELECT (IF r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s;
>>
>> I'm getting an error from that. Is there some way to do this?
>
>
> SELECT IF( r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no' )
> FROM s;


Thanks!
Thread
regexp in conditionalLarry Martell7 Jan 2014
  • Re: regexp in conditionalPeter Brawley7 Jan 2014
    • Re: regexp in conditionalLarry Martell7 Jan 2014
  • Re: regexp in conditionalMichael Dykman7 Jan 2014
    • Re: regexp in conditionalLarry Martell7 Jan 2014