How can the use of OR instead of AND in a search query improve the search results in a PHP application?

Using OR instead of AND in a search query can improve search results in a PHP application by broadening the search criteria. This means that results will be returned if they match any of the search terms, rather than all of them. This can be particularly useful when searching for multiple related keywords or synonyms.

$search_query = "SELECT * FROM products WHERE name LIKE '%keyword1%' OR description LIKE '%keyword2%'";