PHP/MYSQL Help in Table????

[watever]

this is the sample query i'd like to execute:

$a = "SELECT * FROM table_name WHERE $variable LIKE '$search'";

$variable would come from a dropdown menu.