mysql 的查询

//mysql中替换
update gt_looppictures set images = replace(images,'http://pldj.aa.cn','http://www.bb')

//转成一行
SELECT GROUP_CONCAT(id) FROM gt_party_committee where pid='37'

//树节点 根据父类 查询子类

SELECT * FROM ( SELECT t1.*,

IF(FIND_IN_SET(pid, @pids) > 0, @pids := CONCAT(@pids, ',', id), '0') AS ischild

FROM ( SELECT * FROM gt_party_committee AS t  ORDER BY t.pid ASC ) t1,(SELECT @pids := '37') t2) t3 WHERE ischild != '0' 

//嵌套查询
SELECT GROUP_CONCAT( c.id
) as id FROM (SELECT * FROM (SELECT t1.*,IF(FIND_IN_SET(pid, @pids) > 0, @pids := CONCAT(@pids, ',', id), '0') AS ischild  FROM (SELECT * FROM gt_party_committee AS t  ORDER BY t.pid AS) t1,
(SELECT @pids := '37') t2) t3 WHERE ischild != '0' ) as c