File
Add library
Share
Login or Register
Help
HTMLSaved
 
<!DOCTYPE html>
<html>
  <head><meta name="viewport" content="width=device-width, initial-scale=1.0">
    <script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>
​
    <link href="https://nightly.datatables.net/css/dataTables.dataTables.css" rel="stylesheet" type="text/css" />
    <script src="https://nightly.datatables.net/js/dataTables.js"></script>
​
    <meta charset=utf-8 />
    <title>Exact Match Search in DataTables</title>
  </head>
  <body>
    <div class="container">
  <input type="text" id="searchBox" placeholder="Search...">
<table id="example" class="display">
    <thead>
        <tr>
            <th>Name</th>
            <th>Age</th>
            <th>City</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td>&nbsp; John</td>
            <td>28</td>
            <td>Moscow</td>
        </tr>
        <tr>
            <td>&nbsp; Alexey</td>
            <td>34</td>
            <td>Saint Petersburg</td>
        </tr>
        <tr>
            <td>&nbsp; Anna</td>
            <td>22</td>
            <td>Novosibirsk</td>
        </tr>
        <tr>
            <td>&nbsp; Olga</td>
            <td>30</td>
            <td>Yekaterinburg</td>
        </tr>
        <tr>
            <td>&nbsp; Peter</td>
            <td>45</td>
            <td>Kazan</td>
        </tr>
    </tbody>
</table>
    </div>
  </body>
</html>
​
CSSSaved
 
body {
  font: 90%/1.45em "Helvetica Neue", HelveticaNeue, Verdana, Arial, Helvetica, sans-serif;
  margin: 0;
  padding: 0;
  color: #333;
  background-color: #fff;
}
​
JavaScriptSaved
 
​
$(document).ready(function() {
    var table = $('#example').DataTable();
​
    $('#searchBox').on('keyup', function() {
        // Get the input value from the search box
        var searchTerm = $(this).val();
​
        // If there's a search term, perform the search
        if (searchTerm) {
            // Create a regex for the search term (starts with the term + anything after)
            var regex = '^[\s\u00A0] ' + $.fn.dataTable.util.escapeRegex(searchTerm);
​
            // Search only in the first column (index 0)
            table.column(0).search(regex, true, false).draw(); // 0 indicates the first column
        } else {
            // If the search box is empty, show all records
            table.column(0).search('').draw();
        }
    });
});
​
​
1 warning
Line 12: Bad or unnecessary escaping.
Output 300px

This bin was created anonymously and its free preview time has expired. Get a free unrestricted account

Dismiss x
public
Bin info
anonymouspro
0viewers