"the SQL query looks for a column value of ALL the words in the search bar"

This is not what did you expect ?

To perform a case-insensitive search, you need to either change the collation of your columns (they should end with "_ci"), or adjust your PHP code and SQL query to compare only lowercase values, for example.