PHP & MySQL

Chapter 11: SQL

PageTitleFilename
401SELECT Columns From Rows
403WHERE with Comparison Operator 1
403WHERE with Comparison Operator 2
403WHERE with Logical Operator
405LIKE to Search for Matches 1
405LIKE to Search for Matches 2
405LIKE to Search for Matches 3
407ORDER BY to Order Results
407ORDER BY to Order by Multiple Columns
409COUNT to Count Matches
409COUNT to Count Search Results
409COUNT with GROUP BY and ORDER BY
411LIMIT to Limit Matches
411OFFSET to Offset Matches
417JOINs to Get Data from Multiple Tables
419ALIAS for Table Names
419ALIAS for Column Names
421CONCAT to Join Columns
421COALESCE for Missing Values
422Article Data
423Article List Data
425INSERT a Single Row of Data
425INSERT Multiple Rows of Data
427UPDATE a Single Row of Data
427UPDATE Multiple Rows of Data
429DELETE Data