0

Dear All,

I am new to MySQL. Can i retrive the result of a query as the combination of different fields of a single record..

For example..
if the result record of a query is ... id(1), country(India), Location1(maharashtra), Location2(pune), Location3(Navi Mumbai)...

My doubt is that can i retrive the 3 locations as one field..

Please excuse me if this is a foolish question..

Regards,

Jino..

4
Contributors
7
Replies
8
Views
9 Years
Discussion Span
Last Post by AaronASterling
0

if they are all coming from a single table...call it testTable... then you would just say

SELECT location1, location2, location3 FROM testTable  WHERE ....

and then you can fill in whatever goes in the WHERE clause to get the result you want. In general you can list as many fields as you want plus other goodies in the select expression (the part where you tell it what you want) of a SELECT statement. They have to seperated by commas.

0

if they are all coming from a single table...call it testTable... then you would just say

SELECT location1, location2, location3 FROM testTable  WHERE ....

and then you can fill in whatever goes in the WHERE clause to get the result you want. In general you can list as many fields as you want plus other goodies in the select expression (the part where you tell it what you want) of a SELECT statement. They have to seperated by commas.

that's exactly what i've been using

SELECT location1 a, location2 b , location3 c FROM testTable  WHERE  a.someField = b.someOtherField AND b.someOtherField = c.someOtherFieldToo

OR LIKE THIS :

SELECT location1 a LEFT JOIN location2 b ON  a.someField = b.someOtherField WHERE someOtherField = 'blabla'
0

Oh. So thats what it feels like to look like an idiot. I forget if I go more then 20 minutes without putting my foot in my mouth. I'll read more carefully next time

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.