match all query elasticsearch

Label:prerequisite: MySQL function find_in_set (str,strlist), cast (value as type) Find_in_set (str,strlist): If the string str is a string list of n substrings consisting of strlist, the range of return values is 1 to n. If STR is not strlist or strlist is an empty string, the return value is 0. If either parameter is NULL, the return value is null. This function will not work correctly when the first parameter contains a comma (', '). difference between ①find_in_set (str,strlist) and in (): Wh

Obtain all unmatched query results using the Oracle Regular Expression -- Not a numberSelect * from dual whereNot REGEXP_LIKE ('1 is not a number 1', '^ [0-9] + \. {0, 1} [0-9] * $ ') -- Is a numberSelect * from dual whereREGEXP_LIKE ('1. 1', '^ [0-9] + \. {0, 1} [0-9] * $ ') Application Scenario Analysis:Today, we want to process data in the intermediate database that does not conform to the format requ

This article describes the MySQL implementation of tree-like all child node Query method. Share to everyone for your reference, specific as follows: In Oracle we know that there is a hierarchical Queries through connect by we can easily check all the child nodes under the current node. Unfortunately, there is no corresponding functionality in the current version