Search for a word ( like ) query in mysql

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

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

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.