Previously, we covered the SQL SELECT Statement, to pull data from a SQL database. Here, we’ll constrain our search for items that match a given string, or pattern using the WHERE clause to filter search results, rather than getting all of the records and parsing the output. The WHERE clause extracts records that fulfill a specified string and follows the general syntax as follows, replacing the word column with the name of the column in one of your tables and the word table with the name of a table that you’d like to search within: SQL WHERE Syntax SELECT column,column FROM table WHERE column operator value; Below is a selection…
-
-
Facebook Pages
Better late than never. Facebook pages for some of my books: Using Mac OS X Lion Server: https://www.facebook.com/osxserver Enterprise iPhone and iPad Administrator’s Guide: https://www.facebook.com/pages/Enterprise-iPhone-and-ipad-Administrators-Guide/282217275233852 Enterprise Mac Administrator’s Guide: https://www.facebook.com/pages/Enterprise-Mac-Administrators-Guide/190363331102720 Time Machine in Mac OS X Lion: https://www.facebook.com/pages/Time-Machine-In-Mac-OS-X-Lion/448356355230805 Beginning Mac OS X Snow Leopard Server: https://www.facebook.com/pages/Beginning-Mac-OS-X-Snow-Leopard-Server/371061802989330 Enterprise Mac OS X Snow Leopard Security: https://www.facebook.com/pages/Enterprise-Mac-Security-Mac-OS-X-Snow-Leopard/221774031291627 Foundations of Mac OS X Leopard Security: https://www.facebook.com/pages/Foundations-of-Mac-OS-X-Leopard-Security/550986454931475 Mac Tiger Server Little Black Book: https://www.facebook.com/TigerServerLittleBlackBook Will post a few more things soon. Thanks!