$query = $_SGLOBAL[‘db‘]->query("SELECT bf.*, cl.classname, b.* FROM ".tname(‘blog‘)." b 
		LEFT JOIN ".tname(‘blogfield‘)." bf ON bf.blogid=b.blogid JOIN ".tname(‘class‘)." cl ON b.classid=cl.classid 
		WHERE b.uid in(1,4,7)");

mysql in操作,布布扣,bubuko.com

mysql in操作