There was a problem creating the mysql query.

There are 2 tables: in both there are only 2 fields id and title. So, please tell me how to make a selection of records with the condition LIKE by name from both tables.

Closed due to the fact that the essence of the question is not clear to the participants by Denis , αλεχολυτ , cheops , Bald , Kirill Stoianov September 26 '16 at 9:05 .

Try to write more detailed questions. To get an answer, explain what exactly you see the problem, how to reproduce it, what you want to get as a result, etc. Give an example that clearly demonstrates the problem. If the question can be reformulated according to the rules set out in the certificate , edit it .

  • You can just make two requests. Not sure if this is “professional”, but for that it’s convenient and understandable - Rosnowsky

1 answer 1

I think the UNION ALL operator will help you.