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 |
+-----------------------+------------+