Home >Database >Mysql Tutorial >How to write greater than or equal to mysql

How to write greater than or equal to mysql

little bottle
little bottleOriginal
2019-05-29 16:15:3313124browse

How to write greater than or equal to mysql

##Greater than operator>

'>' operator is used to determine whether the operand on the left is greater than the operand on the right. If Greater than, the return value is 1; otherwise the return value is 0. '>' is used for comparison and judgment. This operator cannot be used for null value judgment.

select 'good'>'good',100>2,NULL>NULL;

Greater than or equal to operator>=

'>=' operator is used to determine whether the operand on the left is greater than or equal to the operand on the right. If greater than or equal to, the return value is 1; otherwise, the return value is 0. '>=' cannot be used to determine the null value NULL.

select 'good'>='good',100>=2,NULL>=NULL;

The above is the detailed content of How to write greater than or equal to mysql. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn