How to search records in database by substring?

Question

JavaScript

There is a fio field in the database for users, in which in one line "Last name First name Patronymic".
I get users using fio_contains. But how to make it search immediately for the first word in the line, and then for the rest? And is it even possible to do this?