http://sqle.ru/index.php?action=history&feed=atom&title=MySQL_Tutorial%2FComparison_Functions_Operators%2FIntroductionMySQL Tutorial/Comparison Functions Operators/Introduction - История изменений2026-05-14T05:35:15ZИстория изменений этой страницы в викиMediaWiki 1.30.0http://sqle.ru/index.php?title=MySQL_Tutorial/Comparison_Functions_Operators/Introduction&diff=271&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/Comparison_Functions_Operators/Introduction&diff=272&oldid=prevAdmin: 1 версия2010-05-26T09:49:40Z<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Comparison Functions and Operators==<br />
<br />
<p>Comparison operations result in a value of 1 (TRUE), 0 (FALSE), or NULL.</p><br />
<p>Comparison Functions and Operators work for both numbers and strings.</p><br />
<p>Strings are converted to numbers and numbers to strings as necessary.</p><br />
<p>By default, string comparisons are not case sensitive and use the current character set.</p><br />
Name<br />
Description<br />
BETWEEN AND<br />
Check whether a value is within a range of values<br />
COALESCE()<br />
Return the first non-NULL argument<br />
<=><br />
NULL-safe equal to operator<br />
=<br />
Equal operator<br />
>=<br />
Greater than or equal operator<br />
><br />
Greater than operator<br />
GREATEST()<br />
Return the largest argument<br />
IN<br />
Check whether a value is within a set of values<br />
INTERVAL()<br />
Return the index of the argument that is less than the first argument<br />
IS NULL<br />
NULL value test<br />
IS<br />
Test a value against a boolean<br />
ISNULL()<br />
Test whether the argument is NULL<br />
LEAST()<br />
Return the smallest argument<br />
<=<br />
Less than or equal operator<br />
<<br />
Less than operator<br />
LIKE<br />
Simple pattern matching<br />
NOT BETWEEN ... AND ...<br />
Check whether a value is not within a range of values<br />
!=, <><br />
Not equal operator<br />
NOT IN<br />
Check whether a value is not within a set of values<br />
NOT LIKE<br />
Negation of simple pattern matching<br />
SOUNDS LIKE<br />
Compare sounds<br />
<p>Quote: dev.mysql.ru/doc/refman/5.1/en/index.html</p></div>Admin