city drop down list india for contact form 7

[select india-cities include_blank "Ahmedabad" "Bengaluru/Bangalore" "Chandigarh" "Chennai" "Delhi" "Gurgaon" "Hyderabad/Secunderabad" "Kolkatta" "Mumbai" "Noida" "Pune" "Anantapur" "Guntakal" "Guntur" "kakinada" "kurnool" "Nellore" "Nizamabad" "Rajahmundry" "Tirupati" "Vijayawada" "Visakhapatnam" "Warangal" "Itanagar" "Guwahati" "Silchar" "Bhagalpur" "Patna" "Bhillai" "Bilaspur" "Raipur" "Belgaum" "Bellary" "Bidar" "Dharwad" "Gulbarga" "Hubli" "Kolar" "Mangalore" "Mysoru/Mysore" "Calicut" "Cochin" "Ernakulam" "Kannur" "Kochi" "Kollam" "Kottayam" "Kozhikode" "Palakkad" "Palghat" "Thrissur" "Trivandrum" "Bhopal" "Gwalior" "Indore" "Jabalpur" "Ujjain" "Ahmednagar" "Aurangabad" "Jalgaon" "Kolhapur" "Mumbai" "Mumbai Suburbs" "Nagpur" "Nasik" "Navi Mumbai" "Pune" "Solapur" "Imphal" "Shillong" "Aizawal" "Dimapur" "Bhubaneshwar" "Cuttak" "Paradeep" "Puri" "Rourkela" "Amritsar" "Bathinda" "Chandigarh" "Jalandhar" "Ludhiana" "Mohali" "Pathankot" "Patiala" "Ajmer" "Jaipur" "Jaisalmer" "Jodhpur" "Udaipur" "Gangtok" "Chennai" "Coimbatore" "Cuddalore" "Erode" "Hosur" "Madurai" "Nagerkoil" "Ooty" "Salem" "Thanjavur" "Tirunalveli" "Trichy" "Tuticorin" "Vellore" "Agartala" "Chandigarh" "Dadra & Nagar Haveli-Silvass" "Daman & Diu" "Pondichery" "Agra" "Aligarh" "Allahabad" "Bareilly" "Faizabad" "Ghaziabad" "Gorakhpur" "Kanpur" "Lucknow" "Mathura" "Meerut" "Moradabad" "Noida" "Varanasi/Banaras" "Dehradun" "Roorkee" "Asansol" "Durgapur" "Haldia" "Kharagpur" "Kolkatta" "Siliguri" "Panjim/Panaj" "Vasco Da Gama" "Ahmedabad" "Anand" "Ankleshwar" "Bharuch" "Bhavnagar" "Bhuj" "Gandhinagar" "Gir" "Jamnagar" "Kandla" "Porbandar" "Rajkot" "Surat" "Vadodara/Baroda" "Valsad" "Vapi" "Ambala" "Chandigarh" "Faridabad" "Hisar" "Karnal" "Kurukshetra" "Panipat" "Rohtak" "Dalhousie" "Dharmasala" "Kulu/Manali" "Shimla" "Jammu" "Srinagar" "Bokaro" "Dhanbad" "Jamshedpur" "Ranchi" "other"]

Update One column value in another column in Mysql

Hi,


For updating Value from one column to another use this


update Table_name set Column_name1 = Column_name2


But if  you want to copy specified character from a column then 


update Table_name set Column_name1 =
(
   SELECT LEFT(Column_name2,INSTR(Column_name2,",")-1) 
)



SELECT LEFT(Column_name2,INSTR(Column_name2,",")-1) 

This query will select only characters before ,(Comma).

You can modify it as per your requirement.You can use slash or any other character...

Thanks
Shakun