Allow SELECT on specific column only
For this you need to grant select permission to user (MySQL User) on that particular column of table.

GRANT SELECT (name) ON MyDb.User TO 'MySQLUser'@'MySQLHost';


For explanation have a look at MySQL Documentation on column Privileges