How to use Mysql’s SELECT + WHERE dynamically?

Question

I need to search the Mysql database, however I may have one or more filters (maximum 6) in the WHERE clause.

Example:

SELECT * FROM 'table_name'
WHERE coluna_1 = 'valor_1'

or

SELECT * FROM 'table_name'
WHERE 
     coluna_1 = 'valor_1' AND
     coluna_2 = 'valor_2' AND
     .
     .
     .
     coluna_6 = 'valor_6'

I can save the column name information and the value to be searched for in a variable and then pass in WHERE?

let searchBy = `${coluna_1} = ${valor_1} AND ${coluna_2} = ${valor_2}`

SELECT * FROM 'table_name'
WHERE ${searchBy};