如何在jquery数据表中使用多列过滤器

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="dataTables.min.js"></script>
<link rel="stylesheet" href="dataTables.min.css">

<table id="myTable">
  <thead>
    <tr>
      <th>Name</th>
      <th>Age</th>
      <th>City</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>John</td>
      <td>25</td>
      <td>New York</td>
    </tr>
    <tr>
      <td>Jane</td>
      <td>30</td>
      <td>London</td>
    </tr>
    <!-- 其他行数据 -->
  </tbody>
</table>

$(document).ready(function() {
  $('#myTable').DataTable();
});

$(document).ready(function() {
  $('#myTable').DataTable({
    "searchCols": [
      null,
      null,
      { "search": "London" } // 在第三列中过滤出"London"
    ]
  });
});

<input type="text" id="nameFilter" placeholder="Name">
<button id="filterButton">Filter</button>

$(document).ready(function() {
  var table = $('#myTable').DataTable();

  $('#filterButton').on('click', function() {
    var nameFilterValue = $('#nameFilter').val();
    table.column(0).search(nameFilterValue).draw();
  });
});