Search in base in which more than 10 million lines?

Question

MySQL

There is a table in which more than 10 million lines.
How to search through it with a loop.
For example, we are looking for To display all lines with a suitable value, help implement. Select * from Base WHERE first_name = 'текст'

Answer 1

Will speed up the execution of the query index on first_name.