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

Popular posts from this blog

c# - Send Image in Json : 400 Bad request -

jquery - Fancybox - apply a function to several elements -

An easy way to program an Android keyboard layout app -