select identical records from table

[zohab]

hi all,

 

I want to select identical records from table

 

 

table

 

id firstname lastname email

 

1  first    last    email 

2  xyz      pqr      sss

3  first    last    email

4  mmm      lll      rrr 

5  first    last    email

 

in above table records 1,3 and 5 are identical

 

I want to know select query to get record 1,3 and 5

[peddel]

if u know the value of the identical record u can do this

 

SELECT * FROM table WHERE table.firstname = 'first'

[zohab]

Hi peddel,

 

I do not know the value of identical record

[peddel]

Could u tell me why u need to know the doubles? Cuz im guessing there is more to this.

Try to explain me the situation it is in

[revraz]

You can probably do a self join, see if this helps

 

http://www.phpfreaks.com/forums/index.php/topic,233331.0.html