September 2011
Intermediate to advanced
696 pages
21h 29m
English
Content preview from PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, Fourth EditionBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
7. Advanced SQL and MySQL
In This Chapter
Performing FULLTEXT Searches 222
This, the last chapter dedicated to SQL and MySQL (although most of the rest of the book will use these technologies in some form or another), discusses the higher-end concepts often needed to work with more complicated databases, like those created in the previous chapter. The first such topic is the JOIN, a critical SQL term for querying normalized databases with multiple tables. From there, the chapter introduces a category of functions that are specifically used when grouping query results, followed ...