The Vertica Database Forums

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

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..

See my response in this thread: viewtopic.php?f=75&t=1168