on 11-02-2016 2:06 PM
Hi,
I am using HANA query with "CONTAINS OR" for searing the more than one OR condition for like search.
This is my query.
SELECT * FROM table WHERE DELETE_FLAG=0 AND ( CONTAINS(table.NAME,'%Ascendas Magyarorszag Kereskedelmi Korlatolt Felelossegu Tarsasag% OR %Ascendas (MALAYSIA) SDN BHD%')).
If I use that entire input, I could not get the records.But If I reduce the input length like below query, I can get the records. It seems like there is a data length issue on CONTAINS OR query.
SELECT * FROM table WHERE DELETE_FLAG=0 AND ( CONTAINS(table.NAME,'%Ascendas Magyarorszag% OR %Ascendas (MALAYSIA) SDN BHD%')).
How to achieve that CONTAINS OR query for larger input?
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.