The Little Guy Posted December 28, 2009 Share Posted December 28, 2009 I am trying to make a query, but this query needs to search different tables, but I don't really want to run 1 search on each table so for now, I have these tables: - businesses - people - products - questions each table has (or will have) different columns, in them for example: businesses - name - location - service_quality people - fname - lname - biography products - name - information I would like to make a search, that will search all these tables from JUST a search box, without having to specify a category (business, people, products, questions, etc). What would be the best way to do this with a minimal number of queries? Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/186485-1-query-on-many-tables/ Share on other sites More sharing options...
Daniel0 Posted December 28, 2009 Share Posted December 28, 2009 And how would you imagine this would work when they don't even share the same table structure? Quote Link to comment https://forums.phpfreaks.com/topic/186485-1-query-on-many-tables/#findComment-984860 Share on other sites More sharing options...
ignace Posted December 28, 2009 Share Posted December 28, 2009 Like Daniel already said it becomes hard because they don't share the same table structure SELECT name, concat(location, ':', service_quality) info FROM business WHERE .. UNION SELECT concat(fname, ' ', lname) name, biography info FROM people WHERE UNION SELECT name, information info FROM products WHERE .. Quote Link to comment https://forums.phpfreaks.com/topic/186485-1-query-on-many-tables/#findComment-984999 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.