What is the best way to check if a record exists in a database?

Question

PHP

There are databases. users table. There is registration. What is the fastest and easiest way to check for the presence of the e-mail or username that was entered during registration, for the presence of it in the database?
Is it enough to just make a selection based on the entered e-mail/username, count the number of rows received, and if it is not equal to 0, then terminate the function?

Answer 1

SELECT true FROM users WHERE name = ? OR email = ? LIMIT 1;