웹이야기

MySQL 문자열 함수와 연산자 SPACE() - SPACE(N) 의 형태 Returns a string consisting of N space characters. mysql> SELECT SPACE(6) ; +----------+ | SPACE(6) | +----------+ | | +----------+ 1 row in set (0.00 sec) mysql>

MySQL 문자열 함수와 연산자 REPEAT() - 문자열 반복 REPEAT(str, count) 의 형태 Returns a string consisting of the string str repeated count times. If count is less than 1, returns an empty string. Returns NULL if str or count are NULL. mysql> SELECT REPEAT('오늘은', 5); +-----------------------------------------------+ | REPEAT('오늘은', 5) | +-----------------------------------------------+ | 오늘은오늘은오늘은오늘은오늘은 | +-------..

MySQL 문자열 함수와 연산자 QUOTE() - QUOTE(str) 의 형태 Quotes a string to produce a result that can be used as a property escaped data value in an SQL statement. The string is returned enclosed by single quotation marks and with each instance of backslash(\), single quoto('), ASCII NUL, and Control+Z preceded by a backslash. If the argument is NULL, the return value is the world "NULL" without enclosing si..

MySQL 문자열 함수와 연산자 INSERT() - INSERT(str, pos, len, newstr) 의 형태 Returns the string str, with the substring beginning at position pos and len characters long replaced by the string newstr. Returns the original string if pos is not within the length of the string Replaces the rest of the string from position pos if len is not within the length of the rest of the string. Returns NULL if any argumen..

MySQL 문자열 함수와 연산자 FROM_BASE64() - FROM_BASE64(str) 의 형태 Takes a string encoded with the base-64 encoded rules used by TO_BASE64() and returns the decoded result as a binary string. The result is NULL if the argument is NULL or not a valid base-64 string. mysql> SELECT TO_BASE64('abc'), FROM_BASE64(TO_BASE64('abc')) ; +------------------+-------------------------------+ | TO_BASE64('abc') | FROM_..

MySQL 문자열 함수와 연산자 FORMAT() - FORMAT(X, D [,locale]) 의 형태 Formats the number X to a format like '#, ###,###.##', rounds to D decimal places, and returns the result as a string. If D is 0, the result has no decimal point or fractional part. The optional third parameter enables a locale to be specified to be used for the result number's decimal point, thousands separator, and grouping between separ..

MySQL 문자열 함수와 연산자 FIND_IN_SET() - 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 N substrings. A String list is a string composed of substrings separated by , characters. If the first argument is a constant string and the second is a column of type SET, the FIND_IN_SET() function is optimized to use bit arithmet..