select sku, substring( ordered_pic, 1, length( substring_index( ordered_pic, ,, 1 ) ) ) as pid
from `product`
where `purchaser_id` =13
limit 0 , 30
select id,picture_name from `picture` where `width` =468 and height = 468 and created_at > '2012-08-01' and picture_name like 'w%'
bitscn.com