mysql中判断表中是否存在某条记录

  SELECT
      CASE
      WHEN EXISTS (SELECT *
                   FROM
                     usergroupmap
                   WHERE
                     groupId = groupIdIn
                     AND userId = v_friendId) THEN
        'EXIST'
      ELSE
        'NOT EXIST'
      END
    INTO
      flag;