Facebook
From Speedy Teal, 7 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 262
  1. select * from customers where contactFirstName LIKE 'R%'
  2. select * from customers where contactFirstName LIKE '%i%'
  3. select * from customers where city LIKE '%ll%'
  4. select * from customers where contactFirstName LIKE '%ee' AND country LIKE '%s%'
  5. select * from customers where phone LIKE '+%'
  6. select * from customers where addressLine1 LIKE '%Circus%' AND city = 'Manchester'
  7. select * from customers where customerName LIKE '%Signal%' AND city = '%Las%'
  8. select * from customers where customerName LIKE '%&%' AND city = 'Lyon'
  9. select * from customers where customerName LIKE '%Ltd.%'