mysql字符串处理（MySQL string manipulation）.doc

mysql字符串处理（MySQL string manipulation） Personal view: since MYSQL does not have pattern matching, regular expressions are not supported, and string processing capabilities are not comparable to PHP. The general database, as long as the support of REPLACE (or SUBSTR EXCEL LETT, RIGHT, MID) basically will be enough, but the MYSQL string function is indeed very rich (in fact, date processing function of the MYSQL is also very rich, are these): ASCII (STR) Returns the ASCII code value of the leftmost character of string str. If STR is an empty string, return 0. If STR is NULL, return NULL. ORD (STR) If the left character string STR is a multi byte character, by format ((first byte ASCII code (*256+) second byte ASCII code) [*256+third byte) ASCII code...] return character ASCII code value to return the multi byte character code. If the leftmost character is not a multi - byte character. Returns the same value returned by the ASCII () function. CONV (N, from_base, to_base) Change numbers between different numbers of bases. Returns the string number of the numeric N, from the from_base base to the to_base base, and returns NULL if any parameter is NULL. The parameter N is interpreted as an integer, but can be specified as either an integer or a string. The smallest base is 2, and the largest base is 36. If to_base is a negative number, N is considered a signed number, otherwise N is treated as an unsigned number. CONV works at a precision of 64 loci. BIN (N) Returns a string representation of the binary value N, where N is a long integer (BIGINT) number, which is equivalent to CONV (N, 10,2). If N is NULL, return NULL. OCT (N) Returns the representation of a string of octal value N, where N is a long integer number, which is equivalent to CONV (N, 10,8). If N is NULL, return NULL. HEX (N) Returns a sixteen decimal value N, a string representation, where N is a long integer (BIGINT) number, which is equivalent to CONV (N, 10,16). If N is NULL, return NULL. CHAR (N,...) CHAR