I have a small database of about 30 names that are all unique. The variable $member equals "Ann" but will change depending on the person to search for. I need to be able to return the exact match of the person's first name. I have tried many combinations of the Where clause but I cannot get it to return "Ann" instead of "Anna" since Anna is in the table before Ann.
This returns "Anna" instead of "Ann":
$query = "SELECT * FROM board_members where FirstName like '%$member%'";
These returns nothing:
$query = "SELECT * FROM board_members where FirstName = '$member'";
$query = "SELECT * FROM board_members where FirstName = '%$member%'";
Can someone help me with this?