SUBSTRING(
, str
,pos
)SUBSTRING(
, str
FROM pos
)SUBSTRING(
, str
,pos
,len
)SUBSTRING(
str
FROM pos
FOR len
)
The forms without a len
argument return a substring from string str
starting at position pos
. The forms with a len
argument return a substring len
characters long from string str
, starting at position pos
. The forms that use FROM
are standard SQL syntax.
This function is multi-byte safe.
SUBSTRING_INDEX(
str
,delim
,count
)
Returns the substring from string str
before count
occurrences of the delimiter delim
. If count
is positive, everything to the left of the final delimiter (counting from the left) is returned. If count
is negative, everything to the right of the final delimiter (counting from the right) is returned.
This function is multi-byte safe.
TRIM([{BOTH | LEADING | TRAILING} [
, remstr
] FROM] str
)TRIM(
remstr
FROM] str
)
Returns the string str
with all remstr
prefixes and/or suffixes removed. If none of the specifiers BOTH
, LEADING
, or TRAILING
is given, BOTH
is assumed. If remstr
is optional and not specified, spaces are removed.
This function is multi-byte safe.
UCASE(
str
)
UCASE()
is a synonym for UPPER()
.
UNCOMPRESS(
string_to_uncompress
)
[출처] modestia2004
"쇼핑몰·홈페이지·오픈마켓
블로그·페이스북·이메일 등의 각종 마케팅 글쓰기, 각종 광고, 영업, 판매, 제안서, 전단지 반응율 3배×10배 이상 높이는 마법의 8단계 공식" |
☞자세히보기 |
|
|