DataTables搜索“男性”和“女性”

I am using datatables and it has a built-in search (if that's what you call it), now I'm having problem on searchin gender on my table list because whenever I search for "Male" , both male and female shows up in the list. What will I do so it will filter only the gender "Male" if I search for Male. But Female if I search for Female? I'm sorry if i haven't tried anything because I really don't have an idea. I tried searching though, but those with same problem with mine don't have answer that I understood, so I am just trying that maybe you guys can help me. If you can't because I haven't tried anything, I understand. But I'm still hoping. thank you in advance!

Database Name - db_seq

Table name - Profile

Table columns - name, gender, username, password

EDIT: My code

<?php include('dbcontroller.php');
    $sql = "SELECT name, gender FROM profile ORDER by name ASC";
    $res = mysqli_query($conn,$sql)or die(mysqli_error());
    ?>
    <table id="batchList" class="table table-striped table-bordered" cellspacing="0" width="100%">
        <thead>
            <tr>
                <th>Name</th>
                <th>Gender</th>
            </tr>
        </thead>
        <tfoot>
            <tr>
                <th>Name</th>
                <th>Gender</th>
            </tr>
        </tfoot>        
        <tbody> 
        <?php
        while ($row = mysqli_fetch_array($res)) {
            $name = $row['name'];
            $gender = $row['gender'];
        ?>
            <tr>
                <td><?php echo $name;?></td>
                <td><?php echo $gender;?></td>                  
            </tr>
<?php
    }
?>
    </tbody>
</table>
<?php
mysqli_close($conn);
?>


<script>
$(document).ready(function() {
    $('#batchList').DataTable();
} );
</script>