How to find a record in a database by three criteria?

Question

MySQL

There are three forms for entering the last name, first name and patronymic of the user. How to get user id from MYSQL database by three parameters?

Answer 1

SELECT * FROM users WHERE name='Имя' AND lastname='Фамилия' AND patronymic='Отчество'

Answer 2

The task is not entirely clear.
3 forms with 3 fields and find if entered in one form? Or if the Name is in one and the surname is in the other?
If it's just 3 forms, then what's the problem with listing everything through and and or?
(where name=$name1 and surname=$surname1 and patronymic=$patronymic1) or
(where name=$name2 and surname=$surname2 and patronymic=$patronymic2) or
(where name=$name3 and surname=$surname3 and patronymic= $patronymic3)

Answer 3

I understand that, judging by the question, you have no idea how MySQL works?
Do this:
PHPMyAdmin has a "search" button - click it, enter search parameters, click "find" and phpmyadmin will give you the result, and show you what query it found it with. So you can learn at the initial level how the table is accessed