GK SCIENTIST

General Knowledge One Stop Source
Menu
  • Home
  • Social Science
    • History
    • Political Science
    • Geography
  • Science
    • Physics
    • Chemistry
    • Biology
  • Chemistry Notes
  • Mathematics
  • Computer
  • Tutorial MySQL
  • Tutorial Python
  • Java Tutorial
  • English Grammar
  • English Essay
  • Indian Anthropology
  • Philosophy
  • Solved Paper
  • UPSC
  • Current Content
    • Current Affairs
    • RSTV News
    • Yojana and Kurukshetra Gist
  • Donate
  • Contact Us

If you are interested in advertising to our audience, submit the advertising enquiry form.

Advertising Enquiry
Computer

MySQL Select Query with Where Clause

Gk Scientist November 11, 2022 No Comments
Tweet WhatsApp Telegram

MySQL Select Query with Where Clause:

(1) In the previous blog we learn about MySQL Insert Query to insert data into the database table. Now in this blog, we learn about how to read data from a database table.

(2) If you want to select some columns in a database, then use the below syntax.

SELECT column1, column2, ……….
FROM table_name;

(3) Now open the MySQL Workbench and log in to it. Now go to the table and write the “select” query to get particular columns as shown.

mysql select statement to select particular column - MySQL Select Query with Where Clause

(4) You can also change the column id in the display by using the following query as shown below.

MySQL select query to change column id - MySQL Select Query with Where Clause

(5) If you want to select all columns in a database, then use the below syntax.

SELECT * FROM table_name;
MySQL select query for all data from column - MySQL Select Query with Where Clause

(6) Now we use the WHERE clause with the SELECT statement or query. The WHERE clause is used to filter records. It is used to extract only those records that fulfill a specified condition. The syntax is given below.

SELECT column1, column2, ……….
FROM table_name
WHERE condition

(7) Some basic conditions which we use with the WHERE clause are given below.

=Equal
!=Not Equal
>Greater Than
<Lesser Than
>=Greater than or Equal to
<=Lesser than or Equal to
  • Use Equal Condition:
mysql where clause using equal condition - MySQL Select Query with Where Clause
  • Use Greater Than Condition:
mysql select statement use greater than condition - MySQL Select Query with Where Clause
  • Use Lesser Than Condition:
mysql select statement use lesser than condition - MySQL Select Query with Where Clause
  • Use Greater than or Equal to Condition:
mysql where clause condition Greater than or Equal to - MySQL Select Query with Where Clause
  • Use Not Equal Condition:
mysql where clause Not Equal Condition - MySQL Select Query with Where Clause

Programming Languages
Computer Input Devices
Secondary Storage Devices
World Wide Web (WWW)
Application Software
Operating System as a Resource Manager
MySQL– Wikipedia
Prev Article
Next Article

Related Articles

How to Install PyCharm For Python on Windows
Install PyCharm For Python: (1) Many IDEs (Integrated Development Environment) …
Gk Scientist November 19, 2022 Computer

How to Install PyCharm For Python on Windows

Java for-each Loop
Java for-each Loop: We can use the Eclipse IDE for …
Gk Scientist January 6, 2023 Computer

Java for-each Loop

Python String format() Method
Python String format() Method: We can use the PyCharm code …
Gk Scientist November 26, 2022 Computer

Python String format() Method

Create ComboBox in Java
Create ComboBox in Java: We can use the Eclipse IDE …
Gk Scientist January 16, 2023 Computer

Create ComboBox in Java

Install DB Browser for SQLite on Windows
DB Browser for SQLite: (1) Go to Google chrome and …
Gk Scientist December 7, 2022 Computer

Install DB Browser for SQLite on Windows

Java Method Overriding
Java Method Overriding: We can use the Eclipse IDE for …
Gk Scientist January 10, 2023 Computer

Java Method Overriding

Interface in Java
Interface in Java: We can use the Eclipse IDE for …
Gk Scientist January 11, 2023 Computer

Interface in Java

Artificial Intelligence (AI)
What is Artificial Intelligence? The term Artificial Intelligence was coined …
Gk Scientist October 6, 2022 Computer

Artificial Intelligence (AI)

Leave a Reply Cancel Reply

Search




  • Popular
  • Recent




GK SCIENTIST

General Knowledge One Stop Source

Information

  • About Us
  • Terms and Condition, Disclaimer
  • Contact Us

Android Apps

  • IAS App For English Medium Students
  • IAS Basics App For English Medium Students
  • IAS Hindi App For Hindi Medium Students
DMCA.com Protection Status

Popular Tags

Biology (33) Biology Questions (88) Chemistry (57) Computer (213) Current Affairs (4) Current Content (0) Economy (10) English Essay (172) English Grammar (75) English Literature (10) Geography (83) History (259) Indian Anthropology (11) Indian Polity (14) JKAS Mains Question Papers (17) Mathematics (68) Moral Science (7) NCERT & Other Boards Books (25) Philosophy (114) Physics (89) Political Science (132) RS TV News (33) Science (553) Social Anthropology (7) Social Science (17) Solved Paper (47) UPSC (7) UPSC Mains Question Papers (26)

Downloads

  • NCERT Books
  • Old NCERT Books
  • NIOS Books For IAS, SSC, and State PSC Exam
  • Tamil Nadu Board Books: Important For UPSC, SSC, and State PSC Exam
  • Modern Indian and World History Notes For IAS Exam
  • UPSC Topper 2013 Gaurav Agrawal Notes For IAS Preparation
  • UPSC IAS Prelims General Studies – Previous Year Papers
  • UPSC Mains Question Papers

Copyright © 2023 GK SCIENTIST
Theme by MyThemeShop.com& Hosted On Cloudways

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh
 

Loading Comments...