how to serarch product name

[jxdyzwh]

the ps hava search function,but not to product name the field to search,i want to serarch product name is use like '%keyword%'

[jxdyzwh]

my print sql:

SELECT si.id_product FROM ps_search_word sw   LEFT JOIN ps_search_index si ON sw.id_word = si.id_word WHERE sw.id_lang = 3
AND sw.id_shop = 1 AND sw.word LIKE '%夹克%'

[vekia]

hello

this is how it works in prestashop,

can you shed some light on your question? where the problem is?

[stottycabanas]

Hi vekia,

 

I don't think it works like that in PS.

Say you have a product with the name 'Helicopter'. If your search string is 'Helic', the product will be found.  However if your search string is 'copt', the product will not be found.

It only compares from the beginning of the stored search words.

 

Cheers, Dave

[jxdyzwh]

I agree with Cheers, Dave view,