mysql多列搜索

我有这样一张桌子:

+-------------------+---------------+
| description       | colour        |
+-------------------+---------------+
| Macrame Dress     | Washed Black  |
| Darcelle Gilet    | Dirty Shellac |
| Darcelle Cardigan | Washed Black  |
| Let It Rot Vest   | Optic White   |
| Let It Rot Crew   | Washed Black  |
| Let It Rot Crew   | Optic White   |
| Battalion Short   | Somme         |
| Seine Dress       | Washed Black  |
| Seine Dress       | Cocomotion    |
| Odette V-neck     | Linen Marl    |
+-------------------+---------------+

任何人都可以想到一个非常优雅,漂亮的sql,它将采用任意数量的搜索词并返回最简洁的结果集.我可以想到一些非常丑陋的方法来做这件事,但是他们打乱了我的业力.