MySQL "ordering" (show some value first)

[saljutin]

lets say we have table
id/a/b/c

we want to show "a"

SELECT a FROM table WHERE b=1

it provides what I want ... BUT not exactly
lets say c can be 1,2,3,4 and I want to "show" c=1 on top ... so some sort of order by BUT if c=3 it does not work so lets say like this:
c=3
c=3
c=2
c=4
c=2
c=1

it only matters that that particular c is on top
I was thinking by solving this problem by making 2 queries, but I guess there is some other solution?

[lolninja]

SQL has a built in sort function called ORDER BY, dead simple to use, just list the variables you want to sort your data by and it'll happen.

For example

Code: [Select]

SELECT a FROM table WHERE b=1 ORDER BY c ASC
Has fun

[saljutin]

I think you don't understand me

this is not ORDER BY...what if C is 1,2,3,4,5
and I want this to be DEAD simple but its not

and I want ONE particular value of C to be ON top....
let say you have
b/c
t1/3
t2/1
t3/2
t4/2
t5/4

I want this to arrange that t3/2 and t4/2 is ON TOP

so if I use that "simple" solution of you...which if ofc known
either it will start with c=4 or c=1

[CygnusX]

I don't believe there is a way to custom sort in mysql.  I think you're going to need to load this data into an array, and do a custom sort function that moves these values to the top of your list.  You can then walk the array if need be.

That, or you could run 2 queries.  One that excludes the value of C you're looking for, and one that only has the value of C you want.  This would effectively provide the data you're after.

[Chris]

modulo (%)

Check one topic started by me (it should have "SQL" in title, probably in coding or general board), I had similar problem and people gave some interesting solutions.

[saljutin]

CygnusX - yeah that 2 queries solution would be the easiest to implement...but I was curious if SQL have some sort of command

so Chris I found that post:
SELECT * FROM table ORDER BY c, b == $c

$c is the value that need to be on top...so this will work?

[Harkins]

Code: [Select]

select a from table order by c != 3, c;

[Chris]

Found it http://community.bbgamezone.net/index.php/topic,2847.0.html