my sql select query problem

[bhuwan81]

I have a table name `student` with id 1,2,3,4,5 and name a,b,c,d,e can i have in a single query of my sql suppose name=b in first row of the result. like 2,b shold be in the first row of the result set, in short I want a certain row of the record first then rest of the records is there any such a query in my sql where we can have this type of result.

[asmith]

id    student

1      a

2      b

3      c

4      d

5      e

 

 

what is with the id= 2 and student =b  ?   

 

i assume i'm mysql ! i want to show that row for you , what is with it that it would distinguished it from others rows ? how do i find it for you ?

 

if and only if you know what row to fish out , like "i want information on student "b" .  then you can get others from which aren't "b" !

 

select * from table_name where student != "b"

 

above code shows all except the row which "b" is in .

 

OR you have to have more columns to explain more that student .

[rajivgonsalves]

taking the above the query would be

 

select *,(student='b') as orderclause from table_name order by orderclause;