selecting

[slighltywhacked]

I have a database filled with articles...
there are two types

current
past

they are indicate in a collum named 'type'

Using a select statement in mysql, how could I retrive all the articles in alphabetical order, but have current first...

so it would be current a-z then past a-z
I want to be able to do this in one satement



thanx

[tipiyanos]

SELECT article_text FROM article_table ORDER BY type, article_text 

This should work no? It will first order the query result by type(current/past) and the alphabetical order of article_text.

Hope that helps.

[Milamber]

"SELECT title FROM articles_table ORDER BY age, title ASC" 

That statement will sort the table alphabetically by age (your current/pass column ) first, and then by the title column.

Thus giving you a list with the titles that are in alphabetical order and start over at current/past differences.


I believe this will work, but not sure, so please let me know if it does.



Good luck!

[slighltywhacked]

nope..that dosnt seem to work

[Milamber]

Originally posted by slighltywhacked
nope..that dosnt seem to work

bummer - other than that i suggest you go read the mysql documentation.