Hi I am pretty new to mysql.
I am porting an access driven website to mysql. All has gone pretty much to plan bar one final page. This page is basically a listing of duplicate users based on the email field. In the access db I had a predefined query called emailduplicate The site asp page called a recordset from this query. For starters, can I create a similar stored query with mysql? If so how do I do it? I use mysql front but can see no way to create a stored query similar to access. What I require at the end is a web page listing member records where the emaila ddress occurs more than once. Also all other data associated with each record as the additional data is very likely to be different even if emails are the same. Should it help the original access query stored as email duplicate was as per below. SELECT Members.Email, Members.ID, Members.Worldpayid, Members.yourname, Members.Password, Members.Email2, Members.fullmember, Members.DateFullmemberpaid, Members.unsubcribed, Members.dateunsubscribed, Members.Paidbycheck, Members.dtmMembershipExpires FROM Members WHERE (((Members.Email) In (SELECT [Email] FROM [Members] As Tmp GROUP BY [Email] HAVING Count(*)>1 ))) ORDER BY Members.Email; The asp page used a recorset as follows. Recordset1.Source = "SELECT * FROM emailduplicate ORDER BY Email, fullmember" Any help or advice on how best to achieve the final end result would be appreciated. best wishes Michael
