MYSQL - SQL query Getting single record for the similar records and populating other columns with which has more length
- by Bujji
Here is my case , I have a database table with below fields
name
place_code
email
phone
address
details
estd
others
and example data
if you look at the above example table
First three records are talking about XYZ and place code 1020 .
I want create a single record for these three records based on
substring(name,1,4)
place_code
( I am…
