MySQLi query with more than one word in a parameter
I have a MySQLi query that uses a parameter from a search field on a previous page. It works well with one word searches, but I would like it to search on multiple words if the user adds them. I have seen where you can do that with MySQL (https://stackoverflow.com/questions/30029537/search-multiple-words-in-mysql has some examples) but I have no clue how to transpose that to my query. I would be very grateful for any advice the community can offer.
My query is (and there is probably a neater way of doing this too);
<?php
$DETAILS = new WA_MySQLi_RS("DETAILS",$iPage2,0);
$DETAILS->setQuery("SELECT * FROM business_list WHERE CATEGORIES LIKE ? OR DETAILS LIKE ? OR COMPANY LIKE ? OR COVID_BLURB LIKE ? AND SHOW_ON_WEB = 'YES'");
$DETAILS->bindParam("s", "%".(isset($_POST['param'])?$_POST['param']:"") ."%", "-1"); //colname
$DETAILS->bindParam("s", "%".(isset($_POST['param'])?$_POST['param']:"") ."%", "-1"); //colname 2
$DETAILS->bindParam("s", "%".(isset($_POST['param'])?$_POST['param']:"") ."%", "-1"); //colname 3
$DETAILS->bindParam("s", "%".(isset($_POST['param'])?$_POST['param']:"") ."%", "-1"); //colname 4
$DETAILS->execute();
?>
Thank you in advance for any advice on how to turn this query into a multiple word search.