w3resource
MYSQL Tutorial

MySQL LENGTH() function

LENGTH() function

MySQL LENGTH() returns the length of a given string.

Syntax:

LENGTH (str)

Argument

Name Description
str A string whose length is to be returned.

Syntax Diagram:

MySQL LENGTH() Function - Syntax Diagram

MySQL Version: 5.6

Video Presentation

Example of MySQL LENGTH() function

The following MySQL statement returns the pub_name and length of pub_name from publisher table.

Code:

SELECT pub_name,LENGTH(pub_name) FROM publisher;

Sample table: publisher


Sample Output:

mysql> SELECT pub_name,LENGTH(pub_name) FROM publisher;
+------------------------------+------------------+
| pub_name                     | LENGTH(pub_name) |
+------------------------------+------------------+
| Jex Max Publication          |               19 | 
| BPP Publication              |               15 | 
| New Harrold Publication      |               23 | 
| Ultra Press Inc.             |               16 | 
| Mountain Publication         |               20 | 
| Summer Night Publication     |               24 | 
| Pieterson Grp. of Publishers |               28 | 
| Novel Publisher Ltd.         |               20 | 
+------------------------------+------------------+
8 rows in set (0.03 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-length-function - php mysql examples | w3resource</title>
<meta name="description" content="example-length-function - 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>list of publishers name and length of their name:</h2> <table class='table table-bordered'> <tr> <th>Publishers name</th><th>Length of Publishers name</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,LENGTH(pub_name) FROM publisher') as $row) { echo "<tr>"; echo "<td>" . $row['pub_name'] . "</td>"; echo "<td>" . $row['LENGTH(pub_name)'] . "</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-length-function</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,LENGTH(pub_name) FROM publisher";
rs = statement.executeQuery(Data);
%>
<TABLE border="1">
<tr width="10" bgcolor="#9979">
<td>Publishers name</td>
<td>Length of Publishers name</td>
</tr>
<%
while (rs.next()) {
%>
<TR>
<TD><%=rs.getString("pub_name")%></TD>
<TD><%=rs.getString("LENGTH(pub_name)")%></TD>
</TR>
<%   }    %>
</table>
<%
rs.close();
statement.close();
connection.close();
} catch (Exception ex) {
out.println("Cant connect to database.");
}
%>
</body>
</html>

Example of MySQL LENGTH() function with where clause

The following MySQL statement returns the pub_name and length of pub_name from publisher table who have the length of there is more than or equal to 20.

Code:

SELECT pub_name,LENGTH(pub_name) FROM publisher WHERE LENGTH(pub_name)>=20;

Sample table: publisher


Sample Output:

mysql> SELECT pub_name,LENGTH(pub_name) FROM publisher
    -> WHERE LENGTH(pub_name)>=20;
+------------------------------+------------------+
| pub_name                     | LENGTH(pub_name) |
+------------------------------+------------------+
| New Harrold Publication      |               23 | 
| Mountain Publication         |               20 | 
| Summer Night Publication     |               24 | 
| Pieterson Grp. of Publishers |               28 | 
| Novel Publisher Ltd.         |               20 | 
+------------------------------+------------------+
5 rows in set (0.03 sec)

All String Functions

MySQL String Functions, slide presentation

Many of our valued users post comments along with piece of code. Disqus may, false positively, consider those piece of code as Bad or Starnge syntax and send those comments to spam automatically. Even if that happens, we will make sure those useful comments are taken out of spam and approved. It may take a couple of days for that though, but any useful comment will be brought to public view for sure. We regret if that happend to any user. You may write us directly regarding this to - w3resource[at]yahoo[dot]com.