补充下,除了楼主说的那些要替换,貌似还要把 SELECT field_1 FROM `zone_space` AS `space` LEFT JOIN `zone_spacefield` AS `spacefield` on `space`.`uid`=`spacefield`.`uid` WHERE `field_1` LIKE '%.mp3%' AND `field_1` NOT LIKE '%...%' AND `field_1` NOT LIKE '%=%' AND `space`.`avatar`='1' ORDER BY `space`.`lastlogin` DESC 把里面红色部分换成你的数据表头,例如uchome_space