Is there any Alternate for CONTAINS function in vertica DB?
Hi,
I would like use contains function in vertica to do text search, i got to know it is not avail in vertica, is there any alternative instead of this one? if any can you please let me know? I would like search like below:
for example:
SELECT ID, TEXT FROM ABC.SRVC_TKT WHERE TEXT=('LAPPEE' AND 'CHARGER' OR 'WIRE' |'BATTERY' AND 'BAG'|'ANY' AND 'ACCESSORIES')'
Thanks & Regards,
Kiran
Is there any Alternate for CONTAINS function in vertica DB?
Moderator: NorbertKrupa
-
- Newbie
- Posts: 9
- Joined: Tue May 21, 2013 7:09 am
Re: Is there any Alternate for CONTAINS function in vertica
Hello,
You can use regular expressions for this
The function is regexp_like.
Go through this topic, You can find some hints.
http://www.vertica-forums.com/viewtopic ... like#p3424
Hope this helps..
You can use regular expressions for this
The function is regexp_like.
Go through this topic, You can find some hints.
http://www.vertica-forums.com/viewtopic ... like#p3424
Hope this helps..
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Is there any Alternate for CONTAINS function in vertica
See my response in this thread: viewtopic.php?f=75&t=1168
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.