how to retrive a object object from DB using a non primary key?

IN my application there are users object. they have id, name,age...
I want to add a user named "John" to DB if DB does not already contains a user with "John".
Since primary key is user id, how to do this??

thanks in advance.