SELECT
CONCAT(
LEFT(student_id_card, 6),
‘********’,
RIGHT(student_id_card, 4)
) AS student_id_card
FROM difficulty_job;
mysql关键信息返回 ****
深耕网站建设、视觉设计与SEO优化的一线实战洞察。
SELECT
CONCAT(
LEFT(student_id_card, 6),
‘********’,
RIGHT(student_id_card, 4)
) AS student_id_card
FROM difficulty_job;