How to check if two or more rows have the same field value?

------------------------------------------------------------------------------ select * from table_name where last_name = "usama" LIMIT1 ------------------------------------------------------------------------------ this will return the first occurance of last_name usama

IF the table is like id| First_Name| Last_Name 1 | Saad | Usama 2 | Saad | Usama 3 | Saad | def -------------------------------------------------------------------- I found that it could be handled by the below select statment: select min(m.id) Idenfire , m.First_Name, m.Last_Name from new_table m group by m.First_Name, m.Last_Name ----------------------------------------------------------------- Result: 1 | Saad | Usama 3 | Saad | def

select * from table_name where last_name="usama";