mysql> CREATE TABLE `contact` (
    ->   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    ->   `user_id` bigint(20) unsigned NOT NULL,
    ->   `device_id` bigint(10) unsigned DEFAULT NULL,
    ->   `phone` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
    ->   `name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    ->   `surname` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    ->   PRIMARY KEY (`id`),
    ->   KEY `contact_unique_pair` (`user_id`,phone,`device_id`),
    ->   FULLTEXT KEY `idx_contact_full_name` (`name`,`surname`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Query OK, 0 rows affected (2.30 sec)

mysql> INSERT INTO `contact` (`id`, `user_id`, `device_id`, `phone`, `name`, `surname`) VALUES
    -> (140100, 370100, 150100, '+79000065080002', '3Contact3', NULL);
Query OK, 1 row affected (0.32 sec)

mysql> SELECT contact.id from contact where  contact.user_id = 370100 and MATCH(contact.name, contact.surname) AGAINST ('+3Contact3*' IN BOOLEAN MODE);
+--------+
| id     |
+--------+
| 140100 |
+--------+
1 row in set (0.09 sec)

mysql> SELECT * from contact where  contact.user_id = 370100 and MATCH(contact.name, contact.surname) AGAINST ('+3Contact3*' IN BOOLEAN MODE);
+--------+---------+-----------+-----------------+-----------+---------+
| id     | user_id | device_id | phone           | name      | surname |
+--------+---------+-----------+-----------------+-----------+---------+
| 140100 |  370100 |    150100 | +79000065080002 | 3Contact3 | NULL    |
+--------+---------+-----------+-----------------+-----------+---------+
1 row in set (0.00 sec)

mysql>