使用jquery中的搜索按钮在datatable中自定义过滤器

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.11.3/css/jquery.dataTables.min.css">
<script src="https://cdn.datatables.net/1.11.3/js/jquery.dataTables.min.js"></script>

<table id="myTable">
  <thead>
    <tr>
      <th>Name</th>
      <th>Age</th>
      <th>City</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>John Doe</td>
      <td>25</td>
      <td>New York</td>
    </tr>
    <tr>
      <td>Jane Smith</td>
      <td>30</td>
      <td>London</td>
    </tr>
    <!-- 添加更多的行 -->
  </tbody>
</table>

$(document).ready(function() {
  var table = $('#myTable').DataTable();
  
  $('#searchBtn').on('click', function() {
    var keyword = $('#searchInput').val().toLowerCase();
    
    $.fn.dataTable.ext.search.push(function(settings, data, dataIndex) {
      var name = data[0].toLowerCase();
      var city = data[2].toLowerCase();
      
      if (name.includes(keyword) || city.includes(keyword)) {
        return true;
      }
      
      return false;
    });
    
    table.draw();
    
    // 移除自定义过滤器，以便下次搜索
    $.fn.dataTable.ext.search.pop();
  });
});

<input type="text" id="searchInput">
<button id="searchBtn">Search</button>