You can translate the question and the replies:

like vs contains

What's the different between like and contains under simple condition when create selection view?
user
30-08-2017 19:51:17 -0400

3 Answers

Hi, In Virtual DataPort, 'Like' and 'Contains' are Comparison Operators that are used to perform pattern matching in a query. * Like Operator : You could display the values with specified pattern with wildcard characters (% and _). For example, executing the below query would return the results with field containing the text input1 and input2. ``` Select * from view where field like '%input1%' or field like '%input2%' ``` * Contains operator : You could retrieve the values using external index of an unstructured data sources. It is supported in Aracne and Google Search data sources. For example, executing the below query would return the results with field containing the text input1 and input2. ``` Select * from view where field contains 'input1 AND input2’ ``` For more information on **like** and **contains** operator, have a look at [Comparison Operators ](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/language_for_defining_and_processing_data_vql/comparison_operators/comparison_operators#comparison-operators)of the Virtual DataPort VQL Guide. Hope this helps you.
Denodo Team
31-08-2017 06:42:07 -0400
"contains" operatior is removed in Denodo v8.0
user
10-08-2020 23:23:55 -0400
Hi, Yes, the “contains” operator is deprecated in Denodo 7.0 and it has been removed in Denodo 8.0 as this operator do not belong to the SQL standard. However, there are possible replacements for this operator. You could refer the section[ Contains, Containsand, Containsor and Iscontained Operators](https://community.denodo.com/docs/html/browse/8.0/platform/upgrade/backward_compatibility/changes_in_the_denodo_platform_8.0/features_removed_from_virtual_dataport#contains-containsand-containsor-and-iscontained-operators) of the Denodo Platform Upgrade Guide for more information. Hope this helps!
Denodo Team
19-08-2020 07:27:11 -0400
You must sign in to add an answer. If you do not have an account, you can register here