http://sqle.ru/index.php?action=history&feed=atom&title=MySQL_Tutorial%2FString_Functions%2FIntroductionMySQL Tutorial/String Functions/Introduction - История изменений2026-05-14T10:48:06ZИстория изменений этой страницы в викиMediaWiki 1.30.0http://sqle.ru/index.php?title=MySQL_Tutorial/String_Functions/Introduction&diff=157&oldid=prev в 13:44, 26 мая 20102010-05-26T13:44:56Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:44, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>http://sqle.ru/index.php?title=MySQL_Tutorial/String_Functions/Introduction&diff=158&oldid=prevAdmin: 1 версия2010-05-26T09:49:25Z<p>1 версия</p>
<p><b>Новая страница</b></p><div>== String Functions==<br />
<br />
Name<br />
Description<br />
ASCII()<br />
Return numeric value of left-most character<br />
BIN()<br />
Return a string representation of the argument<br />
BIT_LENGTH()<br />
Return length of argument in bits<br />
CHAR_LENGTH()<br />
Return number of characters in argument<br />
CHAR()<br />
Return the character for each integer passed<br />
CHARACTER_LENGTH()<br />
A synonym for CHAR_LENGTH()<br />
CONCAT_WS()<br />
Return concatenate with separator<br />
CONCAT()<br />
Return concatenated string<br />
CONV()<br />
Convert numbers between different number bases<br />
ELT()<br />
Return string at index number<br />
EXPORT_SET()<br />
Return a string such that for every bit set in the value bits, you get an on string and for every unset bit, you get an off string<br />
FIELD()<br />
Return the index (position) of the first argument in the subsequent arguments<br />
FIND_IN_SET()<br />
Return the index position of the first argument within the second argument<br />
FORMAT()<br />
Return a number formatted to specified number of decimal places<br />
HEX()<br />
Return a string representation of a hex value<br />
INSERT()<br />
Insert a substring at the specified position up to the specified number of characters<br />
INSTR()<br />
Return the index of the first occurrence of substring<br />
IS NULL<br />
NULL value test<br />
IS<br />
Test a value against a boolean<br />
LCASE()<br />
Synonym for LOWER()<br />
LEFT()<br />
Return the leftmost number of characters as specified<br />
LENGTH()<br />
Return the length of a string in bytes<br />
LIKE<br />
Simple pattern matching<br />
LOAD_FILE()<br />
Load the named file<br />
LOCATE()<br />
Return the position of the first occurrence of substring<br />
LOWER()<br />
Return the argument in lowercase<br />
LPAD()<br />
Return the string argument, left-padded with the specified string<br />
LTRIM()<br />
Remove leading spaces<br />
MAKE_SET()<br />
Return a set of comma-separated strings that have the corresponding bit in bits set<br />
MID()<br />
Return a substring starting from the specified position<br />
NOT LIKE<br />
Negation of simple pattern matching<br />
NOT REGEXP<br />
Negation of REGEXP<br />
OCT()<br />
Return a string representation of the octal argument<br />
OCTET_LENGTH()<br />
A synonym for LENGTH()<br />
ORD()<br />
If the leftmost character of the argument is a multi-byte character, returns the code for that character<br />
POSITION()<br />
A synonym for LOCATE()<br />
QUOTE()<br />
Escape the argument for use in an SQL statement<br />
REGEXP<br />
Pattern matching using regular expressions<br />
REPEAT()<br />
Repeat a string the specified number of times<br />
REPLACE()<br />
Replace occurrences of a specified string<br />
REVERSE()<br />
Reverse the characters in a string<br />
RIGHT()<br />
Return the specified rightmost number of characters<br />
RLIKE<br />
Synonym for REGEXP<br />
RPAD()<br />
Append string the specified number of times<br />
RTRIM()<br />
Remove trailing spaces<br />
SOUNDEX()<br />
Return a soundex string<br />
SOUNDS LIKE<br />
Compare sounds<br />
SPACE()<br />
Return a string of the specified number of spaces<br />
STRCMP()<br />
Compare two strings<br />
SUBSTRING_INDEX()<br />
Return a substring from a string before the specified number of occurrences of the delimiter<br />
SUBSTRING(), SUBSTR()<br />
Return the substring as specified<br />
TRIM()<br />
Remove leading and trailing spaces<br />
UCASE()<br />
Synonym for UPPER()<br />
UNHEX()<br />
Convert each pair of hexadecimal digits to a character<br />
UPPER()<br />
Convert to uppercase<br />
<p>Quote: dev.mysql.ru/doc/refman/5.1/en/index.html</p><br />
<br />
== String Operators==<br />
<br />
<=><br />
NULL-safe equal to operator<br />
=<br />
Equal operator<br />
>=<br />
Greater than or equal operator<br />
><br />
Greater than operator<br />
<=<br />
Less than or equal operator<br />
<<br />
Less than operator<br />
!=, <><br />
Not equal operator</div>Admin