w3resource logo


MySQL greater than or equal operator

MySQL greater than or equal operator

Secondary Nav

Description

MySQL greater than or equal operator checks whether one expression is either greater than or equal to another expression.

Syntax

>=

MySQL Version : 5.6

Example: MySQL greater than or equal operator

The following MySQL statement will fetch those publishers form the publisher table who have more than or equal to 10 branch offices.

SELECT pub_name,country,pub_city,no_of_branch       
FROM publisher           
WHERE no_of_branch>=10;

Sample table: publisher

Output

mysql> SELECT pub_name,country,pub_city,no_of_branch       
    -> FROM publisher           
    -> WHERE no_of_branch>=10;
+--------------------------+---------+-----------+--------------+
| pub_name                 | country | pub_city  | no_of_branch |
+--------------------------+---------+-----------+--------------+
| Jex Max Publication      | USA     | New York  |           15 | 
| BPP Publication          | India   | Mumbai    |           10 | 
| Mountain Publication     | USA     | Houstan   |           25 | 
| Summer Night Publication | USA     | New York  |           10 | 
| Novel Publisher Ltd.     | India   | New Delhi |           10 | 
+--------------------------+---------+-----------+--------------+
5 rows in set (0.00 sec)

PHP script

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>example-greater-than-or-equal-operator- php mysql examples | w3resource</title>
<meta name="description" content="example-greater-than-or-equal-operator- php mysql examples | w3resource">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
</head>
<body>
<div class="container">
<div class="row">
<div class="col-md-12">
<h2>A list of the publishers whose Number of branches are ten or more. List also includes their date of country,city, number of branches:</h2>
<table class='table table-bordered'>
<tr>
<th>Publishers</th><th>Country</th><th>City</th><th>Number of branches</th>
</tr>
<?php
$hostname="your_hostname";
$username="your_username";
$password="your_password";
$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>=10') 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>";
}
?>
</tbody></table>
</div>
</div>
</div>
</body>
</html>

View the example in browser

JSP script

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>example-greater-than-or-equal-operator</title>
</head>
<body>
<%
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
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>=10";
rs = statement.executeQuery(Data);
%>
<TABLE border="1">
<tr width="10" bgcolor="#9979">
<td>pub_name</td>
<td>Country</td>
<td>City</td>
<td>Number of branches</td>
</tr>
<%
while (rs.next()) {
%>
<TR>
<TD><%=rs.getString("pub_name")%></TD>
<TD><%=rs.getString("country")%></TD>
<TD><%=rs.getString("pub_city")%></TD>
<TD><%=rs.getString("no_of_branch")%></TD>
</TR>
<%   }    %>
</table>
<%
rs.close();
statement.close();
connection.close();
} catch (Exception ex) {
out.println("Can’t connect to database.");
}
%>
</body>
</html>

Slideshow of MySQL Comparison Function and Operators

MySQL Comparison Function and Operators, slide presentation



Is this content useful for you?