I need list of India state in MySQL

Asked By 40 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Little Sweatman
Answered By 0 points N/A #198331

I need list of India state in MySQL

qa-featured

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

Best Answer
Best Answer
Answered By 0 points N/A #142883

I need list of India state in MySQL

qa-featured

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

Login/Register to Answer

Related Questions