ecostore搜索注意事项

ecostore搜索时会把特殊字符转换为相应的文字

如 洋河480ml_52°天之蓝 进行html url编码时会把_(下划线)转换成%25xia%25(%25对应的ascii是%)

搜索时会把%、xia当做搜索关键词,由此造成搜索不匹配。

1 AND `sdb_b2c_goods`.marketable='true' AND (name LIKE '%480ml%' or bn like '480ml%' or goods_id IN (1) )and(name LIKE '%xia%' or bn like 'xia%' )and(name LIKE '%52%' or bn like '52%' or goods_id IN (1) )and(name LIKE '%洋河%' or bn like '洋河%' or goods_id IN (1) )and(name LIKE '%%%' or bn like '%%' or goods_id IN (1) )and(name LIKE '%%%' or bn like '%%' or goods_id IN (1) )and(name LIKE '%°天之蓝%' or bn like '°天之蓝%' or goods_id IN (1) ) AND `sdb_b2c_goods`.goods_type='normal'

 

posted @ 2013-12-23 14:43  魔天06  阅读(213)  评论(0编辑  收藏  举报