<span style="color:#;">select </span> <span style="color:#981a1a;">* </span> <span style="color:#;">from </span> <span style="color:#;">stuinfo </span> <span style="color:#;">where </span> <span style="color:#;">stu_name </span> <span style="color:#981a1a;">&lt;&gt;</span> <span style="color:#aa1111;">'</span> <span style="color:#aa1111;">张三</span> <span style="color:#aa1111;">' </span> 

讯享网<span style="color:#;">select </span> <span style="color:#981a1a;">* </span> <span style="color:#;">from </span> <span style="color:#;">stuinfo </span> <span style="color:#;">where </span> <span style="color:#;">stu_name</span> <span style="color:#981a1a;">!=</span> <span style="color:#aa1111;">'</span> <span style="color:#aa1111;">张三</span> <span style="color:#aa1111;">' </span> 

<span style="color:#aa5500;">4、/*</span> <span style="color:#aa5500;">模糊查询： </span> 

讯享网<span style="color:#aa5500;">关键字：</span> <span style="color:#aa5500;">like </span> 

<span style="color:#aa5500;">通配符：</span> <span style="color:#aa5500;">%:0</span> <span style="color:#aa5500;">个或多个任意字符 </span> 

讯享网<span style="color:#aa5500;">_</span> <span style="color:#aa5500;">：单个字符 </span> 

<span style="color:#aa5500;">[]</span> <span style="color:#aa5500;">：表示在这个范围之内 </span> 

讯享网<span style="color:#aa5500;">[^]</span> <span style="color:#aa5500;">：表示不在这个范围之内 </span> 

<span style="color:#aa5500;">*/ </span> 

讯享网<span style="color:#981a1a;">--</span> <span style="color:#;">查询学生信息表中姓李学生的信息 </span> 

<span style="color:#;">select </span> <span style="color:#981a1a;">* </span> <span style="color:#;">from </span> <span style="color:#;">stuinfo </span> <span style="color:#;">where </span> <span style="color:#;">stu_name </span> <span style="color:#;">like </span> <span style="color:#aa1111;">'</span> <span style="color:#aa1111;">李</span> <span style="color:#aa1111;">%' </span> 

讯享网<span style="color:#981a1a;">--</span> <span style="color:#;">查询学生信息表中姓李且名字只有一个单字的学生的信息 </span> 

<span style="color:#;">select </span> <span style="color:#981a1a;">* </span> <span style="color:#;">from </span> <span style="color:#;">stuinfo </span> <span style="color:#;">where </span> <span style="color:#;">stu_name </span> <span style="color:#;">like </span> <span style="color:#aa1111;">'</span> <span style="color:#aa1111;">李</span> <span style="color:#aa1111;">_' </span> 

讯享网<span style="color:#981a1a;">--</span> <span style="color:#;">查询学生信息表中姓李或姓张学生的信息 </span> 

<span style="color:#;">select </span> <span style="color:#981a1a;">* </span> <span style="color:#;">from </span> <span style="color:#;">stuinfo </span> <span style="color:#;">where </span> <span style="color:#;">stu_name </span> <span style="color:#;">like </span> <span style="color:#aa1111;">'</span> <span style="color:#aa1111;">李</span> <span style="color:#aa1111;">%' </span> <span style="color:#;">or </span> <span style="color:#;">stu_name </span> <span style="color:#;">like </span> <span style="color:#aa1111;">'</span> <span style="color:#aa1111;">张</span> <span style="color:#aa1111;">%' </span> 

讯享网<span style="color:#;">select </span> <span style="color:#981a1a;">* </span> <span style="color:#;">from </span> <span style="color:#;">stuinfo </span> <span style="color:#;">where </span> <span style="color:#;">stu_name </span> <span style="color:#;">like </span> <span style="color:#aa1111;">'[</span> <span style="color:#aa1111;">李张</span> <span style="color:#aa1111;">]%' </span> 

讯享网

<span style="color:#981a1a;">--</span> <span style="color:#;">查询学生信息表中即不是姓李的学生，也不是姓张的学生信息。 </span> 

讯享网<span style="color:#;">select </span> <span style="color:#981a1a;">* </span> <span style="color:#;">from </span> <span style="color:#;">stuinfo </span> <span style="color:#;">where not </span> <span style="color:#;">stu_name </span> <span style="color:#;">like </span> <span style="color:#aa1111;">'</span> <span style="color:#aa1111;">李</span> <span style="color:#aa1111;">%' </span> <span style="color:#;">and not </span> <span style="color:#;">stu_name </span> <span style="color:#;">like </span> <span style="color:#aa1111;">'</span> <span style="color:#aa1111;">张</span> <span style="color:#aa1111;">%' </span> 

<span style="color:#;">select </span> <span style="color:#981a1a;">* </span> <span style="color:#;">from </span> <span style="color:#;">stuinfo </span> <span style="color:#;">where </span> <span style="color:#;">stu_name </span> <span style="color:#;">like </span> <span style="color:#aa1111;">'[^</span> <span style="color:#aa1111;">李张</span> <span style="color:#aa1111;">]%' </span> 

讯享网<span style="color:#981a1a;">--</span> <span style="color:#;">排序：</span> <span style="color:#;">order </span> <span style="color:#;">by </span> 

<span style="color:#981a1a;">--</span> <span style="color:#;">语法格式：</span> <span style="color:#;">select </span> <span style="color:#981a1a;">* </span> <span style="color:#;">from </span> <span style="color:#981a1a;">&lt;</span> <span style="color:#;">表名</span> <span style="color:#981a1a;">&gt; </span> <span style="color:#;">order by </span> <span style="color:#;">字段名 </span> <span style="color:#;">ASC</span> <span style="color:#;">/DESC </span> 

讯享网<span style="color:#981a1a;">--</span> <span style="color:#;">注意：如果按升序排序，可以省略</span> <span style="color:#;">asc</span> <span style="color:#;">，默认就是以升序进行排序；如果是降序，不可以省略</span> <span style="color:#;">desc </span> 

<span style="color:#981a1a;">--</span> <span style="color:#;">注意：如果有多个字段参与排序，优先级按从左至右进行排序 </span> 

讯享网<span style="color:#981a1a;">--</span> <span style="color:#;">案例：查询学生的信息，并按照年龄的升序进行排序 </span> 

<span style="color:#;">select </span> <span style="color:#981a1a;">* </span> <span style="color:#;">from </span> <span style="color:#;">stuinfo </span> <span style="color:#;">order by </span> <span style="color:#;">stu_age </span> <span style="color:#;">asc </span> 

讯享网<span style="color:#;">select </span> <span style="color:#981a1a;">* </span> <span style="color:#;">from </span> <span style="color:#;">stuinfo </span> <span style="color:#;">order by </span> <span style="color:#;">stu_age </span> 

<span style="color:#981a1a;">--</span> <span style="color:#;">案例：查询学生的信息，并按照年龄的降序进行排序 </span> 

讯享网<span style="color:#;">select </span> <span style="color:#981a1a;">* </span> <span style="color:#;">from </span> <span style="color:#;">stuinfo </span> <span style="color:#;">order by </span> <span style="color:#;">stu_age </span> <span style="color:#;">desc </span> 

<span style="color:#981a1a;">--</span> <span style="color:#;">案例：查询学生的信息，并按照年龄降序进行排序，按照学号的升序进行排序 </span> 

讯享网<span style="color:#;">select </span> <span style="color:#981a1a;">* </span> <span style="color:#;">from </span> <span style="color:#;">stuinfo </span> <span style="color:#;">order by </span> <span style="color:#;">stu_age </span> <span style="color:#;">desc</span> <span style="color:#;">,stu_id </span> <span style="color:#;">asc </span> 

<span style="color:#981a1a;">--</span> <span style="color:#;">案例：查询学生的信息，并按照学号降序进行排序，按照年龄的升序进行排序 </span> 

讯享网<span style="color:#;">select </span> <span style="color:#981a1a;">* </span> <span style="color:#;">from </span> <span style="color:#;">stuinfo </span> <span style="color:#;">order by </span> <span style="color:#;">stu_id </span> <span style="color:#;">desc</span> <span style="color:#;">,stu_age </span> <span style="color:#;">asc </span> 

<span style="color:#981a1a;">--</span>