mysql关键信息返回 ****
SELECT
CONCAT(
LEFT(student_id_card, 6),
‘********’,
RIGHT(student_id_card, 4)
) AS student_id_card
FROM difficulty_job;
SELECT
CONCAT(
LEFT(student_id_card, 6),
‘********’,
RIGHT(student_id_card, 4)
) AS student_id_card
FROM difficulty_job;