Select all where first letter starts with B

Question

This is a follow up question to my previous one  I want to write a MYSQL statement that echoes every entry that starts with letter B    Function php  function getCategory      query   mysql query  SELECT author FROM lyrics WHERE author  starts with letter B    or die mysql error     while   row   mysql fetch assoc  query       gt       lt p gt  lt a href      gt  lt     row  author      gt  lt  a gt  lt  p gt       lt  php     Category php category b   lt  php include  includes header php    gt   lt  php getCategory      gt   lt  php include  includes footer php    gt    Like that I guess  And then one for every letter of the alphabet  and one with misc  numbers etc

User · Answer

You can use   WHERE LEFT  name field  1     B

User · Answer

Following your comment posted to ceejayoz s answer  two things are messed up a litte     first is not an array  it s a string  Replace  first    first 0        by  first         Just for simplicity   PHP string operators  The string being compared with LIKE operator should be quoted  Replace LIKE    first     by LIKE     first        MySQL String Comparison Functions

User · Answer

SELECT author FROM lyrics WHERE author LIKE  B      Make sure you have an index on author  though

User · Answer

This will work for MYSQL  SELECT Name FROM Employees WHERE Name REGEXP    B        In this REGEXP stands for regular expression  and   this is for T-SQL  SELECT Name FROM Employees WHERE Name LIKE   B

User · Answer

SQL Statement    SELECT   FROM employee WHERE employeeName LIKE  A      Result   Number of Records  4  employeeID  employeeName    employeeName    Address City    PostalCode  Country  1           Alam             Wipro          Delhi   Delhi   11005      India  2           Aditya           Wipro          Delhi   Delhi   11005      India  3           Alok             HCL            Delhi   Delhi   11005      India  4           Ashok            IBM            Delhi   Delhi   11005      India

[mysql] Select all where [first letter starts with B]

Examples related to mysql