How to make two requests in one?

Question

MySQL

Goodnight! How can I combine two queries in mysql?

SELECT *, CONCAT(lastname,' ', firstname,' ', middlname) fio, 
desired_profession, phone1, phone2, email1, payment 
as concat FROM profil  LIMIT 100

and this one
(`desired_profession` REGEXP 'продавец|продаж' )

Answer 1

SELECT 
    *, 
    CONCAT(lastname,' ', firstname,' ', middlname) fio, 
    desired_profession, 
    phone1, 
    phone2, 
    email1, 
    payment as concat
FROM profil
WHERE desired_profession REGEXP 'продавец|продаж'
LIMIT 100