PHP mysqli search multiple tables

Question

I'm trying to search through 3 different tables however it doesn't seem to be working. I have to remove username from the users table and then it works. How can I search different columns in each table?

$query = "(SELECT name, 'talent' FROM talent WHERE name LIKE '%" . $q ."%') 
           UNION ALL
           (SELECT name, username, 'users' FROM users WHERE name LIKE '%" . $q ."%') 
           UNION ALL
           (SELECT name, 'venues' FROM venues WHERE name LIKE '%" . $q ."%')";

Every UNIONed subquery must return exactly the same number of columns. Every corresponding column must be of compatible type as well. — zerkms
– zerkms, Commented Oct 13, 2014 at 0:31

radar · Accepted Answer · 2014-10-13 00:35:00Z

1

Your first and last UNION are returning 2 columns

The middle UNION is returning 3 columns , so removing username didn't give error

Number of columns and type of columns should be same while using UNION

answered Oct 13, 2014 at 0:35

radar

13.4k2 gold badges27 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2570937 Over a year ago

how could i do it if they don't have the same number columns and type of columns?

radar Over a year ago

@user2570937, you need to give empty value or NULL value if column doesn't have value in one of the select

Collectives™ on Stack Overflow

PHP mysqli search multiple tables

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related