Last post Mar 16, 2013 07:44 AM by rimagandhi
Mar 15, 2013 01:45 PM|tvb2727|LINK
How would I query a database to find duplicate users by a user name? Say the user had a name of joe_smith1 and joe_smith2? How would I find that for the whole table?
Mar 15, 2013 04:46 PM|march11|LINK
These are not duplicates and as such would not be compared or identified as being a duplicate!!!
Mar 15, 2013 09:57 PM|tvb2727|LINK
Sorry, maybe I didn't describe it correct. In the system I am working on, joesmith1 and joesmith2 would be duplicate user accounts in the sense of the user's data. Now you're right, their account id's would be seperate. So how can I query a database to find
where the username are close?
Mar 16, 2013 07:33 AM|Ajay2707|LINK
select * from username
where userid in
select useid, username from usertable where username = SUBSTR( username, 0 , 5)'
use substr and instr function to validate same user string and simple check count of it . pls check this link
Mar 16, 2013 07:44 AM|rimagandhi|LINK
select * from FeasibilityMaster
where Feasibility_Id in
select Feasibility_Id from FeasibilityMaster where Feasibility_Id like '%Feasi_14032013_1%'