Search Results
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
mysql> SELECT FIELD('Bb', 'Aa', 'Bb', 'Cc', 'Dd', 'Ff'); -> 2 mysql> SELECT FIELD('Gg', 'Aa', 'Bb', 'Cc', 'Dd', 'Ff'); -> 0 FIND_IN_SET(str,strlist) Returns a value in the range of 1 to N if the string str is in the string list strlist consisting of ...For functions that operate on string positions, the first position is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-string-functions-operators.html
With the exception of the FORMAT() function, string functions and operators described in the following table are supported with variable-length encoded columns. FIELD() Index (position) of first argument in subsequent arguments FIND_IN_SET() Index ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
For a workaround, see the discussion of SUBSTRING() and CAST() later in this section. The solution is to use SUBSTRING() (or CAST(), as described later in this section). For a functional key part containing the SUBSTRING() function to be used in a ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/8.4/en/regexp.html
If this value is 0, REGEXP_INSTR() returns the position of the matched substring's first character. If this value is 1, REGEXP_INSTR() returns the position following the matched substring. REGEXP_SUBSTR() takes these optional arguments: pos: The ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
For information about using JSON data in MySQL, see Section 13.5, “The JSON Data Type”. Filter definitions have this form, where actions indicates how filtering takes place: { "filter": actions } The following discussion describes permitted ...
https://dev.mysql.com/doc/ndbapi/en/ndbapi-examples-array-adapter.html
This program inserts CHAR, VARCHAR, and BINARY column data into a table by constructing aRef objects using array adapters of the type defined in common/array_adapter.hpp (see Section 2.5.15, “Common Files for NDB API Array Examples”). It then ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
Before upgrading to the latest MySQL 8.4 release, ensure the upgrade readiness of your current MySQL 8.3 or MySQL 8.4 server instance by performing the preliminary checks described below. Tip Consider using the MySQL Shell upgrade checker utility ...
https://dev.mysql.com/doc/refman/8.4/en/bit-functions.html
Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-routing-guidelines-syntax.html
SUBSTRING_INDEX("foo bar baz","a", 2): returns foo bar b STARTSWITH('str1', 'str2'): checks if the str2 string is a prefix of str1. CONTAINS('str1', 'str2'): checks if the str2 string is a substring of str1, case insensitive. The top-level ...