Linux Shell Scripting Cookbook - Third Edition

Selecting rows from a SQL database

The select command will select all the rows that match a test:

    SELECT fields FROM table WHERE test; 

This command will select book titles that include the word Shell from the book table:

    SELECT title FROM book WHERE title like '%Shell%';