What database are you using?
In any case SQL LIKE and OR does not work well especially with MySQL.
In case you do use MySQL and it happens to be 5.6.4 or more recent you can add fulltext indexes and rework queries to use that. See this document
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
and this one
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html#function_match