Categories: MySQL

Filter Rows Using WHERE Statement

Share

In SELECT statement you can filter with condition to get actual result. Using WHERE clause you will get the data from the table that you exactly need.

Here is sample sql for Filter Rows:

SELECT name, address FROM users WHERE state = 'AL';

Recent Posts

The Sharp-Looking Guy: 5 Essential Tips for Men to Become Sharp

We've gotten so used to seeing men streetwear joggers, ripped jeans, and sleeveless shirts. Hair…

2 days ago

How to Use Your Wedding Jewellery In Unique Ways At Festivals

When it comes to festivals, the options for wedding jewellery are endless. You can go…

2 days ago

5 Tips On Window Cleaning

Whether it concerns your home or an office building, the state of a property’s windows…

2 days ago

Sustainable Business Practices: A Win-Win Strategy

You know that running an environmentally sustainable business is the right thing to do. But…

2 days ago

Unlock Growth – Guide to Online Financing and Business Loans for Entrepreneurs

If you are in a financial crisis , or need to start a new business…

2 days ago

7 Key Factors That Help In Selecting the Best Fleet Management Software

To realize the strategic advantage from the fleet management system (FMS) and differentiate the business…

2 days ago