php - Mysql returning only on row with group by query when multiple exist -
i have mysql table such
id,row1,row2,row3
and have entries
id | row1 | row2 | row3 ------------------------------- 1 | 10 | 5 | 10 2 | 20 | 5 | 10
and when run sql this
select * `table` row3 = 10 group row2
it returns 1 row. want return both rows.
any appreciated guys
select * `table` row3 = 10 group row2
the group row2 tells take rows row2's value same , display them (a summary entry).
if want see rows, remove group command
select * `table` row3 = 10
Comments
Post a Comment