LIKE

1. SELECT title, author_fname FROM books WHERE author_fname LIKE '%da%';
2.  
3. SELECT title, author_fname FROM books WHERE author_fname LIKE 'da%';
4.  
5. SELECT title FROM books WHERE title LIKE 'the';
6.  
7. SELECT title FROM books WHERE title LIKE '%the';
8.  
9. SELECT title FROM books WHERE title LIKE '%the%';

% = anything

_ = character

1. SELECT title, stock_quantity FROM books;
2.  
3. SELECT title, stock_quantity FROM books WHERE stock_quantity LIKE '____';
4.  
5. SELECT title, stock_quantity FROM books WHERE stock_quantity LIKE '__';
6.  
7. (235)234-0987 LIKE '(___)___-____'
8.  
9. SELECT title FROM books;
10.  
11. SELECT title FROM books WHERE title LIKE '%\%%'
12.  
13. SELECT title FROM books WHERE title LIKE '%\_%'