[SOLVED] Select beginning

[dreamwest]

Im trying to select rows base on a letter a. So i need to select all rows starting with the letter a

 

id  |  column

1  | apple

2  | bannana

3  | orange

etc

 

So i need a query that will only select id 1 which starts with the letter a

 

This searches for a in the whole string

$search = "a";
$sql = "SELECT * FROM tags where (tag like '%".$search."%') order by tag DESC limit 10";

[Ken2k7]

<?php
$search = 'a';
$sql = 'SELECT * FROM tags WHERE tag LIKE "' . $search '%" ORDER BY tag DESC LIMIT 10';

[dreamwest]

Just had to change wildcard to right side of query

 

$search = "a";
$sql = "SELECT * FROM tags where (tag like '".$search."%') order by tag DESC limit 10";

[dreamwest]

<?php
$search = 'a';
$sql = 'SELECT * FROM tags WHERE tag LIKE "' . $search '%" ORDER BY tag DESC LIMIT 10';

 

Thanks. I worked it out as u posted