MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE test (
  member_name VARCHAR(100)
);
INSERT INTO test VALUES ('ANSHUMAN'), ('A'), ('TINA');
SELECT CONCAT(LEFT(member_name, 1), REPLACE(SUBSTR(member_name, 2), 'A', ''))
FROM test;

CONCAT(LEFT(member_name, 1), REPLACE(SUBSTR(member_name, 2), 'A', ''))

ANSHUMN

A

TIN

SELECT REGEXP_REPLACE(member_name, '[A]+', '', 2)
FROM test;

REGEXP_REPLACE(member_name, '[A]+', '', 2)

ANSHUMN

A

TIN