MYsql question: how to order by certain letter?

I read that 2x and still not sure what you mean exactly. This will return all records where title value begins with C

SELECT * FROM table WHERE LEFT(title,1) hahahaha "C"

replace hahahaha with equals sign.

Why is equal sign banned? WTF?

Ill give an example of what im trying to do.

Say i have these sites in my database and the titles are:

Asian Girls
Black Girls
Ebony Girls
Zoo Girls

How do I order these sites starting from lets say letter E so they will appear like:

Ebony Girls
Zoo Girls
Asian Girls
Black Girls

Hope that helps explain what im trying to do.

I doubt you can do this with a single query in MySQL. It's a two query thing, or you can just do one big select and sort stuff with PHP.

St Lunatic,

As dnsmonster stated you would need to do this with 2 queries.

Assuming you want to sort it by title and the columns name was 'TITLE' you would use the following 2 queries

SELECT * FROM `table_name` WHERE LEFT(`TITLE`,1) = 'C';

SELECT * FROM `table_name` WHERE LEFT(`TITLE`,1) != 'C' ORDER BY LEFT(`TITLE`,1) < 'C', LEFT(`TITLE`,1);

The first query gets all the links with a title that starts with C. The second query gets all links whos titles do not start with c sorting it by whether the left character is greater than C or not with a secondary sort of the leftmost character. This forces it to show up in the format you need while still maintaining the alphabetical listing. If you need any more help feel free to ask.


Regards,
Kevin

Thanks guys, running the 2 querys worked did exactly what I was wanting to do.


Thanks-

better use

SELECT * FROM `table_name` WHERE `TITLE`LIKE 'C%';

as it uses the index (otherwise mysql runs through the whole table). but the TITLE field must be char or varchar in order to index it...