Home > Database > Mysql Tutorial > body text

How to write greater than or equal to mysql

little bottle
Release: 2019-05-29 16:15:33
Original
13101 people have browsed it

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;
Copy after login

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;
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
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
Latest Articles by Author
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template