Форум пользователей MySQL

mysql> create table a (id int, name_user varchar(50), lastname varchar(50));
Query OK, 0 rows affected (0.42 sec)

mysql> insert into a values (1,'иван','петров'),(2,'иван','иванов'),(3,'петр','сидоров'),(4,'петр','петров');
Query OK, 4 rows affected (0.30 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> select * from a where name_user like 'иван' or lastname like 'петров';
+------+-----------+----------+
| id   | name_user | lastname |
+------+-----------+----------+
|    1 | иван      | петров   |
|    2 | иван      | иванов   |
|    4 | петр      | петров   |
+------+-----------+----------+
3 rows in set (0.36 sec)