PHP PDO来自查询

Question

I am trying to do a query in PHP PDO where it will grab a simple result. So like in my query I need it to find the row where the column group is 'Admin' and show what ever is in the group column. I know that we already know what it should be [Should be admin] but just need to get the query to work. Its only grabbing 1 row from my table, so will I need forsearch?

If I change WHERE group = 'Admin' to WHERE id = '1' it works fine. But I need it so it can be where group = 'admin'

$sql2 = "SELECT * FROM groups WHERE group = 'Admin'";
$stm2 = $dbh->prepare($sql2);
$stm2->execute();
$users2 = $stm2->fetchAll();

foreach ($users2 as $row2) {
    print ' '. $row2["group"] .' ';
}

Thanks

Answer 1

try to use wildcard in your WHERE Clause:

$sql2 = "SELECT * FROM groups WHERE group LIKE '%Admin%'";

Since the value in your table is not really Admin but Administrator then using LIKE and wildcard would search the records which contains admin.