Re: REG: REGEXP in Phoenix Queries

2015-07-21 Thread Ns G
Thanks Thomas. I will try out. On 22-Jul-2015 6:24 am, "Thomas D'Silva" wrote: > The default regex functions just use Java Pattern > > > On Tue, Jul 21, 2015 at 2:28 AM, Ns G wrote: > > Hi All, > > > > I have a requirement for using Regular expression. I am trying below > query > > but it doesnt

Re: REG: REGEXP in Phoenix Queries

2015-07-21 Thread Thomas D'Silva
The default regex functions just use Java Pattern On Tue, Jul 21, 2015 at 2:28 AM, Ns G wrote: > Hi All, > > I have a requirement for using Regular expression. I am trying below query > but it doesnt seem to work. > > SELECT el_id from element where el_name like > REGEXP_SUBSTR(el_name,'^[Z][A-

REG: REGEXP in Phoenix Queries

2015-07-21 Thread Ns G
Hi All, I have a requirement for using Regular expression. I am trying below query but it doesnt seem to work. SELECT el_id from element where el_name like REGEXP_SUBSTR(el_name,'^[Z][A-Za-z0-9 \.]*') I dont know if this is correct usage or not. If you can point me any source where i can get it