Search for a word ( like ) query in mysql

Elastic Stack Elasticsearch
1

Hi,
I need help. I am looking to search for black

cat:dresses, color:Black, color:Blue, color:Pink, DPSID48965, Gretchen Scott, subcat:cocktail:cat:dresses, women, z_global_id:37430
Black, Blue, boohoo, cat:dresses, DZZ01081, New Arrivals, Purple, Red, subcat:cocktail:cat:dresses, women, z_global_id:37459

I am searching using match, multi match both return match value.

Black, Blue, boohoo, cat:dresses, DZZ01081, New Arrivals, Purple, Red, subcat:cocktail:cat:dresses, women, z_global_id:37459

But It should return record which have following data as well.

cat:dresses, color:Black, color:Blue, color:Pink, DPSID48965, Gretchen Scott, subcat:cocktail:cat:dresses, women, z_global_id:37430

Any help will be highly appreciated.

thanks

2

Please show mappings, documents as well as queries so we can see in detail and recreate what you are experiencing.