On Tue, Jan 7, 2014 at 12:33 PM, Michael Dykman wrote:
> I think you just have a misplaced parenthesis. try:
> SELECT IF(r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s;
Yes, thanks!
>
>
>
> On Tue, Jan 7, 2014 at 2:22 PM, Larry Martell wrote:
>
>> Can I use an regexp in a conditional?
On Tue, Jan 7, 2014 at 12:31 PM, Peter Brawley
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
I think you just have a misplaced parenthesis. try:
SELECT IF(r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s;
On Tue, Jan 7, 2014 at 2: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
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' )
F
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?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http