MySQL less than or equal operator

less than or equal operator

MySQL less than or equal operator checks whether an expression is either less than or equal to another expression.



MySQL Version : 5.6


The following MySQL statement will fetch those publishers from the publisher table who have less than or equal to 6 branch offices.


SELECT pub_name,country,pub_city,no_of_branch
FROM publisher       
WHERE no_of_branch<=6;

Relational Algebra Expression:

Relational Algebra Expression: MySQL less than or equal operator.

Relational Algebra Tree:

Relational Algebra Tree: MySQL less than or equal operator.

Sample table: publisher

Sample Output:

mysql> SELECT pub_name,country,pub_city,no_of_branch
    -> FROM publisher       
    -> WHERE no_of_branch<=6;
| pub_name                     | country   | pub_city  | no_of_branch |
| New Harrold Publication      | Australia | Adelaide  |            6 | 
| Pieterson Grp. of Publishers | UK        | Cambridge |            6 | 
2 rows in set (0.02 sec)

PHP script:

<!doctype html>
<html lang="en">
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>example-less-than-or-equal-operator- php MySQL examples | w3resource</title>
<meta name="description" content="example-less-than-or-equal-operator- php MySQL examples | w3resource">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
<div class="container">
<div class="row">
<div class="col-md-12">
<h2>List of publishers whose number of branches are six or less, along with their country, city and number of branches:</h2>
<table class='table table-bordered'>
<th>Publisher</th><th>Country</th><th>City</th><th>Number of branches</th>
$db = "your_dbname";
$dbh = new PDO("MySQL:host=$hostname;dbname=$db", $username, $password);
foreach($dbh->query('SELECT pub_name,country,pub_city,no_of_branch
FROM publisher
WHERE no_of_branch<=6') as $row) {
echo "<tr>";
echo "<td>" . $row['pub_name'] . "</td>";
echo "<td>" . $row['country'] . "</td>";
echo "<td>" . $row['pub_city'] . "</td>";
echo "<td>" . $row['no_of_branch'] . "</td>";
echo "</tr>"; 

View the example in browser

JSP script:

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<!DOCTYPE html>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
try {
String Host = "jdbc:MySQL://localhost:3306/w3resour_bookinfo";
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
connection = DriverManager.getConnection(Host, "root", "datasoft123");
statement = connection.createStatement();
String Data ="SELECT pub_name,country,pub_city,no_of_branch FROM publisher WHERE no_of_branch<=6";
rs = statement.executeQuery(Data);
<TABLE border="1">
<tr width="10" bgcolor="#9979">
<td>Number of branches</td>
while (rs.next()) {
<%   }    %>
} catch (Exception ex) {
out.println("Can’t connect to database.");

Online Practice Editor:

Slideshow of MySQL Comparison Function and Operators

MySQL Comparison Function and Operators, slide presentation

Previous: LEAST()

Follow us on Facebook and Twitter for latest update.

We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook