Is there a way to separate a MySql statement by space with a LIKE statement?

Is there a way to separate a MySql statement by space with a LIKE statement?

SELECT school WHERE school LIKE '%suny at albany%';
This will result in Suny at Albany.
If I were to type in:
SELECT school WHERE school LIKE '%suny albany%';
Returns nothing
Is there a way to separate the white space characters so that there are
LIKE statements between them.
so that when I enter 'suny albany', it will return 'SUNY at Albany'. Like
below :
SELECT school WHERE school LIKE '%suny%' AND school LIKE '%albany%';