I need list of India state in MySQL

Asked By elyssaguadalupe 40 points N/A Posted on - 05/05/2013

Hi.  I'm trying to make a database using MySQL with a drop-down menu.  Can someone here help me out with the command line of the list of India state in MySQL?  Any help would be much appreciated.  Thanks in advance.

• Status: Open
• Question Views: 737
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: General

Best Answer by Little Sweatman

Go To Solution

Answered By Huffman Serafin 0 points N/A #198331

I need list of India state in MySQL

Hi Elyssaguadalupe,

I think you can try this query in MySQL. Select 'India' from 'Country' where <some parameters>. This is the normal code for searching specific queries on MySQL program. You can see more of them on their website inside in the documentation. You can also learn more of the syntaxes on YouTube, there are available video tutorials there

About Huffman Serafin

Questions
0

Answers
326

Best Answers
60

• Vote Up 0 Vote Down

• Posted on - 05/18/2013
• Question Category: General

Best Answer

Best Answer

Answered By Little Sweatman 0 points N/A #142883

I need list of India state in MySQL

The SQL statement would be something like the following:

SELECT state_name FROM Country WHERE upper(country_name) = 'INDIA' ;

Where "Country" is your table name, "state_name" is the column name where the list of states is stored, and "country_name" the column where the list of countries is stored.

The use of UPPER() function is to be sure to make the right selection as you need to respect cases

About Little Sweatman

Questions
2

Answers
12

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 05/19/2013
• Question Category: General