user1333327 user1333327 - 1 year ago 66
MySQL Question

Select all where [first letter starts with B]

This is a follow up question to my previous one. I want to write a mysql statements that echoes every entry that starts with letter B.


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)) { ?>
<p><a href="##"><?= $row['author']; ?></a></p>
<?php }


<?php include 'includes/header.php' ?>
<?php getCategory(); ?>
<?php include 'includes/footer.php' ?>

Like that I guess. And then one for every letter of the alphabet, and one with misc (numbers etc)

Answer Source
SELECT author FROM lyrics WHERE author LIKE 'B%';

Make sure you have an index on author, though!

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download