MIS 301 Lecture Notes - Lecture 16: Mysql, Result Set, Middle-Earth Dwarf Characters
Document Summary
Where can be combined with and, or, and not. And = if all the conditions separated by and are true. Or = if any of the conditions separated by or is true. Not = if none of the conditions are true. To sort results in ascending or descending order (asc or desc) The order by function sorts in ascending by default. A field with a null value is a field with no value. Used to specify the number of records to return. Mysql database (which i think is the one we use in class) uses limit not. Min() = returns smallest value in selected column. Max() = returns largest value in selected column. Count() = returns the number of rows that matched the criteria. Avg() = returns average value of a numeric column. Sum() = returns the sum of values in a numeric column. Like is used in a where clause to search for a specified pattern in a column.