Select all where [first letter starts with B]

by 
SELECT author FROM lyrics WHERE author LIKE 'B%';

Make sure you have an index on author, though!

More Related Contents:

  1. SQL split values to multiple rows
  2. Find duplicate records in MySQL
  3. MySQL order by before group by
  4. MySQL Cannot Add Foreign Key Constraint
  5. Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)
  6. MySQL: selecting rows where a column is null
  7. Difference between float and decimal data type
  8. Convert timestamp to date in MySQL query
  9. Update a column value, replacing part of a string
  10. mysql dynamic query in stored procedure
  11. mysql: get record count between two date-time
  12. MySQL Insert Into from one Database in another
  13. How to remove all MySQL tables from the command-line without DROP database permissions? [duplicate]
  14. How to select one row randomly taking into account a weight?
  15. auto_increment by group
  16. GROUP BY – do not group NULL
  17. Composite key as foreign key (sql)
  18. Sort the rows according to the order specified in WHERE IN clause
  19. Multiple Table Select vs. JOIN (performance)
  20. How can I use SQL’s YEAR(), MONTH() and DAY() in Doctrine2?
  21. Is MySQL Temporary table a shared resource?
  22. MySQL distinction between e and é (e acute) – UNIQUE index
  23. Comparing with NULL values
  24. How to import a SQL Server .bak file into MySQL?
  25. Find method to store an IP in MySQL for better performance
  26. Should I always prefer MySQL InnoDB over MyISAM?
  27. MySQL add 12 hours to a time field
  28. OSX ld: library not found for -lssl
  29. Ruby on Rails – cannot load such file — mysql2/2.2/mysql2 (LoadError)
  30. MySQL: Find Missing Dates Between a Date Range

Leave a Comment