Can i retrive different fields of a record as one result.

Short answer: yes. There are two common ways to return several location fields as a single column depending on how your data is stored.

If the three locations are columns in the same row, use MySQL string functions to concatenate them into one result. CONCAT_WS is convenient because it skips NULL values (so you don’t get a NULL result if one column is empty):

SELECT id,
       CONCAT_WS(', ', Location1, Location2, Location3) AS locations
FROM your_table;

If locations are stored as separate rows (the normalized approach that @kevindougans suggested), aggregate them with GROUP_CONCAT after joining the child table:

SELECT c.id, c.country,
       GROUP_CONCAT(l.name ORDER BY l.name SEPARATOR ', ') AS locations
FROM countries c
JOIN locations l ON l.country_id = c.id
GROUP BY c.id;

Notes and tips:

• GROUP_CONCAT can truncate long lists; raise group_concat_max_len for large outputs (session or global) if needed.
• CONCAT returns NULL if any argument is NULL; CONCAT_WS avoids that. Use IFNULL/COALESCE when you need to substitute defaults.
• Prefer normalizing (one location per row) rather than columns Location1..N when the number of locations is variable. That makes indexing, searching and maintenance far easier.
• For searching by partial city names, a plain LIKE '%term%' works but has performance limits; consider fulltext indexes (InnoDB supports them) or a dedicated search engine for large datasets.

Also: @silviuks’s & suggestion is from other SQL dialects — in MySQL use CONCAT/CONCAT_WS. For @jino: either approach will give a single “locations” field; choose concatenation for fixed columns, aggregation for related rows.