일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 |
- Data and Time Functions
- String Functions and Date Operators
- 전자정부 표준프레임워크
- MySQL
- 방화벽
- HTTP
- Oracle
- 오라클
- 전자정부표준프레임워크
- Tibero
- Sring Functions and Operators
- 티베로
- String Function and Operators
- 윈도우
- Date and Time Function
- SVN
- String Functions and Operators
- Date and Time Functions
- Today
- Total
목록String Functions and Operators (39)
웹이야기
MySQL 문자열 함수와 연산자 LPAD() - LPAD(str, len, padstr) 의 형태 Returns the string str, left-padded with the string padstr to a length of len characters. If str is longer than len, the return value is shortened to len characters. mysql> SELECT LPAD('hi', 4, '??') ; +---------------------+ | LPAD('hi', 4, '??') | +---------------------+ | ??hi | +---------------------+ 1 row in set (0.00 sec) mysql> SELEC..
MySQL 문자열 함수와 연산자 LOWER() - LOWER(str) 의 형태 Returns the string str with all characters changed to lowercase according to the current character set mapping. The default is utf8mb4. (MySQL 8. x 버전 이상부터 일 것이다.) mysql> SELECT LOWER('ABCD') ; +---------------+ | LOWER('ABCD') | +---------------+ | abcd | +---------------+ 1 row in set (0.00 sec) LOWER() (and UPPER()) are ineffective when applied to b..
MySQL 문자열 함수와 연산자 LOCATE() - LOCATE(substr, str) LOCATE(substr, str, pos) 의 형태 The first syntax returns the position of the first occurence of substring substr in string str. The second syntax returns the position of the first occurence of substring substr in string str, starting at position pos. Returns 0 if substr is not in str. Returns NULL if any argument is NULL. mysql> SELECT LOCATE('bar',..
MySQL 문자열 함수와 연산자 LOAD_FILE() - LOAD_FILE(file_name) 의 형태 Reads the file and returns the file contents as a string. To use this function, the file must be located on the server host, you must specify the full path name to the file, and you must have the FILE privilege. The file must be readable by the server and its size less than max_allowed_packet bytes. If the secure_file_priv system variable..
MySQL 문자열 함수와 연산자 LEFT() - LEFT(str, len) 의 형태 Returns the leftmost len characters from the string str, or NULL if any argument is NULL. mysql> SELECT LEFT ('foobarbar', 5) ; +-----------------------+ | LEFT ('foobarbar', 5) | +-----------------------+ | fooba | +-----------------------+ 1 row in set (0.00 sec) mysql> SELECT LEFT ('foo', 5) ; +-----------------+ | LEFT ('foo', 5) | +------------..
MySQL 문자열 함수와 연산자 LCASE() - LCASE(str) 의 형태 LCASE() is a synonym for LOWER(). LCASE() used in a view is rewritten as LOWER() when storing the view's defination. (Bug #12844279)
MySQL 문자열 함수와 연산자 HEX() - HEX(str) HEX(N) 의 형태 For a string argument str, HEX() returns a hexadecimal string representation of str where each byte of each character in str is converted to two hexadecimal digits. (Multibyte characters therefore become more than two digits.) The inverse of this operation is performed by UNHEX() function. For a numeric argument N, HEX() returns a hdxadecimal string..
MySQL 문자열 함수와 연산자 FIELD() - FIELD(str, str1, str2, str3, ...) 의 형태 Returns the index (position) of str in the str1, str2, str3, ... list. Returns 0 if str is not found. If all arguments to FIELD() are strings, all arguments are compared as strings. If all arguments are numbers, they are compared as numbers. Otherwise , the arguments are compared as double. If str is NULL, the return value is 0 b..
MySQL 문자열 함수와 연산자 EXPORT_SET() - 이건 뭔가 싶다. EXPORT_SET(bits, on, off[, sperator[,number_of_bits]]) 의 형태 Return a string such that for every bit set in the value bits, you get an on string and for every bit not set in the value, you get an off string. Bits in bits are examined from right to left(from low-order to high-order bits). Strings are added to the result from left to right, separated by th..
MySQL 문자열 함수와 연산자 ELT() - ELT(N, str1, str2, str3....) 의 형태 ELT() returns the N th element of the list strings: str1 if N=1, str2 if N=2, and so on. Retruns NULL if N is less than 1 or greater than the number of arguments. ELT() is the complement of FIELD(). mysql> SELECT ELT(1, 'A', 'B', 'C'); +-----------------------+ | ELT(1, 'A', 'B', 'C') | +-----------------------+ | A | +-----------------..
MySQl 문자열 함수와 연산자 CONCAT_WS() - 문자열 이어붙이는 CONCAT() 의 특별한 형태, 구분자가 함께 한다. CONCAT_WS(sperator, str1, str2) 의 형태 CONCAT_WS() stands for Concatenate With Sperator and is a special form of CONCAT(). The frist argument is the separator for the rest of the arguments. The separator is added between the strings to be concatenated. The sepatator can be a string, as can the rest of the arguments. If the se..
MySQL 문자열 함수와 연산자 CONCAT() - 문자열 이어붙이기 정도 CONCAT(str1, str2...) 의 형태 Returns the string that results from concatenating the arguments. May have one or more arguments. If all arguments are nonbinary strings, the result is a nonbinary string. If the arguments include any binary strings, the result is a binary string. A numeric argument is converted to its equivalent nonbinary string form. CONCAT()..
MySQL 문자열 함수와 연산자 CHARACTER_LENGTH() - CHARACTER_LENGTH(str) 의 형태 CHARACTER_LENGTH() is a synonym for CHAR_LENGTH().
MySQL 문자열 함수와 연산자 CHAR_LENGTH() - CHAR_LENGTH(str) 의 형태 Returns the length of the string str, measured in characters. A multibyte character counts as a single character. This means that for a string containing five 2-byte characters. LENGTH() returns 10, whereas CHAR_LENGTH() returns 5.
MySQL 문자열 함수와 연산자 CHAR() - CHAR(N, ...[USING charset_name]) 의 형태 CHAR() interprets each argument N as an integer and returns a string consisting of the characters given by the code values of those integers. NULL value are skipped. mysql> SELECT CHAR(77, 121, 83, 81, '76'); +-----------------------------+ | CHAR(77, 121, 83, 81, '76') | +-----------------------------+ | MySQL | +-----------------..
MySQL 문자열 함수와 연산자 BIT_LENGTH() - BIT_LENGTH(str) 의 형태 Returns the length of the string str in bits. mysql> SELECT BIT_LENGTH('test'); +--------------------+ | BIT_LENGTH('test') | +--------------------+ | 32 | +--------------------+ 1 row in set (0.00 sec)
MySQL 문자열 함수와 연산자 BIN() - BIN(N) 의 형태 Returns a string representation of the binary value of N. where N is a longlong (BIGINT) number. This is equivalent to CONV(N, 10, 2). Returns NULL if N is NULL. mysql> SELECT BIN(12) ; +---------+ | BIN(12) | +---------+ | 1100 | +---------+ 1 row in set (0.00 sec)
MySQL 문자열 함수와 연산자, ASCII() - 문자열 중에서 가장 왼쪽의 문자열에 대해 숫자값으로 바꿔준다. ASCII(str) 의 형태 Return the numeric value of the leftmost character of the string str. Returns 0 if str is the empty string. Returns NULL if str is NULL. ASCII() works for 8-bit characters. mysql> SELECT ASCII(2); +----------+ | ASCII(2) | +----------+ | 50 | +----------+ 1 row in set (0.00 sec) mysql> SELECT ASCII('DX'); +----------..
MySQL 문자열 함수와 연산자 Name Description ASCII() Return numeric value of left-most character BIN() Return a string containing binary representation of a number BIT_LENGTH Return length of argument in bits CHAR() Return the character for each integer passed CHAR_LENGTH() Return number of characters in argument CHARACTER_LENGTH() Synonym for CHAR_LENGTH() CONCAT() Return concatenated string CONCAT_WS() ..