How would you like the more generic solution to work? every time there is a word containing chair, remove anything but chair? you need to give some specifics on what you want.
sorry, haven't used the setFilter method of adding comparisons before, you would change it to:
$rsProducts->addFilter("ProductName","LIKE","s","%".$productName."%");