Changes between Version 3 and Version 4 of Ticket #13, comment 5


Ignore:
Timestamp:
05/09/2011 04:39:50 PM (15 years ago)
Author:
lidarong
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #13, comment 5

    v3 v4  
    24241.索引图处理 
    2525通过Index2取得所有索引图(及原图) 
    26 select pdl_product_pic.*,replace(pic_path,'_sn.','.') as pic from pdl_product_pic where type=5 and pic_path like '%_sn.%' 
     26select pdl_product_pic.*,replace(pic_path,'_sn.','.') as pic from pdl_product_pic where type=5 and pic_path like '%_sn.%' and pic_path like 'http://img.%'; 
    2727 
    28282.方位图 
    29 select * from pdl_product_pic where type=0  
     29select * from pdl_product_pic where type=0 and pic_path like 'http://img.%'; 
    3030