comparison operator between in mysql

mysql between

comparison operator between in mysql General Syntax – mostly used SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2; expr BETWEEN min AND max If expr is greater than or equal to min and expr is less than or equal to max, BETWEEN returns 1, otherwise it returns 0. This is equivalent to the expression (min <= expr AND expr <= … Read more