MySQL Specifies that search criteria can be searched using the where condition.
In the SELECT statement, the data is filtered according to the conditions specified in the Where child statement, which is given after the table name.
The product table is as follows:
A find a line with a price equal to 2.50
There are the following kinds of operators for the where statement, and with these operators you can filter the conditions accordingly:
Operator |
Description |
= |
Equals |
<> |
Not equal to |
! = |
Not equal to |
< |
Less than |
<= |
Less than or equal |
> |
Greater than |
>= |
Greater than or equal |
Between |
Specify a value between two |
B-Character Retrieval
C Retrieve all products with a price less than 10:
D retrieving the range of values
I would like to sort the results in the search after the display, but this does not seem to be possible, may be a select after only one clause://made an obvious mistake W H e R e spelling mistakes, more xianxueniaoli13 correction!
After the condition is filtered, the Order keyword can be sorted again, which shows the powerful database function.