[MySql 5.0.45-community-nt] Order by Case When and CHAR_LENGTH

[Miguel61]

Hello there, I hope your help.

I have problem with this query and your order.

SET @Name = 'D';

SELECT
	Name
      , Group

FROM
	tbl_Names
WHERE
	(
		Group LIKE CONCAT('%' ,@Name, '%')
		AND CHAR_LENGTH(Group)BETWEEN 1
		AND 4
	)
ORDER BY
	CASE
WHEN CHAR_LENGTH(@Name)= 1 THEN
	1
ELSE
	0
END;
Query OK, 0 rows affected
+-----------------------+------------+
| Name                  | Group      |
+-----------------------+------------+
| DANIEL T              | D100       |
| DAVID  L              | D200       |
| DENISE C              | D300       |
| DONALD S              | D300       |
| IR FIRST GROUP        | D          |
+-----------------------+------------+
5 rows in set

I need this other output when CHAR_LENGTH(@Name)= 1.
Can you help me?

+-----------------------+------------+
| Name                  | Group      |
+-----------------------+------------+
| IR FIRST GROUP        | D          |
| DANIEL T              | D100       |
| DAVID  L              | D200       |
| DENISE C              | D300       |
| DONALD S              | D300       |
+-----------------------+------------+

[r937]

change this --

ORDER BY
	CASE
WHEN CHAR_LENGTH(@Name)= 1 THEN
	1
ELSE
	0
END;

to this --

ORDER BY
	CASE
WHEN CHAR_LENGTH(@Name)= 1 THEN
	0
ELSE
	1
END
, Group

[Miguel61]

thanks alot!