SQLite - check if row exists

How to check if row exists in the SQLite database? I would like to check out if "name" (String) will be duplicated in database if I add a new one. I am still learning, I think that it would be achieved with the cursor.