Hi,

I have a query which works fine for 2 keywords next to each other. For example "red-widget" will display all "red widgets" but it will not display "red-large-widgets"

Can anyone advise how I can query the keywords "red widget" whilst still display both "red widgets" and "red large widgets".


Code:
$query = "SELECT name, linkname, product_id, price, discount, image_link
									FROM furniture_groups a
									INNER JOIN productdbase b
									ON a.id = b.product_id
									WHERE linkname LIKE '%$linkname%'";