官术网_书友最值得收藏!

Filtering data

Until now, we have dealt with data retrieval where all the data in the students table is being retrieved, but seldom do we need all that data. We have used the LIMIT and OFFSET clauses that have allowed us to limit the amount of data were retrieved. Now let us use MariaDB's filtering mechanism to retrieve the data by supplying search criteria. To perform a search in a SQL statement, we will use the WHERE clause. The WHERE clause can be used with the SELECT statement, or it can be even used with the UPDATE and DELETE statements, which will be discussed in the next section:

Filtering data

In the preceding example, we are selecting the students' records whose last_name is Dane.

Filtering data

In the preceding example, we are selecting the students' records whose student_id is 1.

Filtering data

In the preceding example, we are selecting the students' records whose student_id is greater than 1.

Filtering data

In the preceding example, we are selecting the students' records whose student_id is less than 4.

Filtering data

In the preceding example, we are selecting the students' records whose student_id is between 1 and 4, the between clause is inclusive, so the records with student_id 1 and 4 are also retrieved. The following table lists the common operators that can be used for data filtering:

Data can also be filtered by utilizing multiple search criteria by using the AND and OR operators, by employing multiple column search criteria, by using wildcard filtering, by using the IN operator, and so on. As this chapter will only deal with basic filtering, we will not be covering these advanced filtering concepts. The basic filtering in this chapter can be used as a foundation to delve deeper into understanding the advanced concepts of filtering.

主站蜘蛛池模板: 视频| 武汉市| 宿州市| 明光市| 铁岭市| 五大连池市| 鄢陵县| 密云县| 富宁县| 永丰县| 紫阳县| 梅州市| 滦平县| 松滋市| 尼木县| 军事| 宜昌市| 高陵县| 万盛区| 肥东县| 肇庆市| 白银市| 原阳县| 荥阳市| 犍为县| 桐柏县| 紫金县| 郸城县| 安化县| 丰城市| 寻乌县| 青岛市| 海城市| 昔阳县| 峨山| 任丘市| 澄城县| 宾阳县| 海宁市| 普兰店市| 翁源县|