Hi,

I am trying to filter all oak living room furniture. Current I can only filter oak coffee tables. But I am stuck on how to filter oak coffee tables and oak sideboards.

Can anyone advise how I can filter but always using one keyword?



This displays all oak coffee tables.

Code:
WHERE linkname LIKE '%oak%' and linkname LIKE '%coffee%'";
This is displays nothing

Code:
WHERE linkname LIKE '%oak%' and linkname LIKE '%coffee%' and linkname LIKE '%sideboard%'";
This displays all oak coffee tables and all sideboards of any material.

Code:
WHERE linkname LIKE '%oak%' and linkname LIKE '%coffee%' or linkname LIKE '%sideboard%'";