How combine these queries

Hi All,
Here are queries,
"select * from product WHERE LastName like concat(?, '%')"
"Select concat(FirstName, ' ' , LastName) as FullName, Product_id from Customer join product where customerId = id"
Above both queries working individually fine when I tried to combine these, I can't get any results.
I want to combine the above two queries, where the user gives input "Full Name" and it should display the result.

My second question is how to populate match results, I mean when users...

How combine these queries

from MySQL https://ift.tt/2Yn9gDS
via IFTTT