John Davidson

MySQL + PHP search and return multiple types


My goals is returning multiple types from a search query. I have two tables of users and movies. If search query is 'Mat', i should return both results for users with name like '%mat%' and movies with title '%mat%'.

I can use UNION or JOIN two tables in one request, but i guess there will be ordering problem.

For example i have this structure:

Users table:

id name
1 Mat

My Answer:
2_Matt____3_Mateo____Movies table:_____id_title_____1_Matrix____2_Matilda____3_Batman____If i use UNION, the result will be like this:_1_Mat_2_Matt_3_Mateo_1_Matrix_2_Matilda_3_Batman_The ordering is mixed between users and movies. I want to separate the results for users and movies. Is there any way to achieve this?

Rate this post

3 of 5 based on 1594 votes


© 2024 - Personal Blogs Platform. All Rights Reserved.
Create blog  |  Privacy Policy  |  Terms & Conditions  |  Contact Us