Archives of the TeradataForum
Message Posted: Thu, 12 Mar 2015 @ 13:46:39 GMT
Could you help me to fix this query?
select col1,col2 from db.table where regexp_similar(col2,'.*issu.*','i')=1; Output Col1 Col2 7 CHMIC-ISSU:IFL goes down after ISSU, changing configuration issue 3 BGP authentication-key issue
In the above result, first record ISSU is valid however second record got picked up wrongly. I.e how can I differentiate the issu and issue and pick only issu records?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|