Wednesday, February 19, 2020

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 '%\_%'

No comments:

Post a Comment

Right Joins

-- OUR FIRST RIGHT JOIN (seems the same as a left join?) SELECT * FROM customers RIGHT JOIN orders     ON customers.id = orders.custom...