Pulling things out of MYSQL....

Pests

Using mysql, is there a way to only select the cells that have a certain letter as the first leter of the cell data? Im trying to do a A-Z index, but i only want to pull out ones that correspond with the selected letter.

TalonFinsky

Yes, just use a LIKE.

Example:

$query = "select * from TABLENAME where COLUMNAME like 'a%'";

$result = mysql_query($query);

That will return everything for the rows where COLUMNAME starts with "a".

Pests

Okay, thanks. Its $letter% correct?

TalonFinsky

Well for that you would want to do something like:

$query = "select * from TABLENAME where COLUMNAME like '".$letter."%'";

$result = mysql_query($query);

Pests

I know, just giving a short example.

TalonFinsky

Originally posted by Pests
I know, just giving a short example.

Gotcha. Good luck!

jmarco

What if you wanted to display Column Names that began with letters A-F?

$query = "select * from TABLENAME where COLUMNAME like 'a%', 'b%',..., 'f%'";

$result = mysql_query($query);

Would that do the trick?

If so would it sort the records A through F or would it output them in the order they were listed in the db?