Friday 23 May 2014

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"]

Tuesday 13 May 2014

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