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.
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
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
