0.1.34
Pre-release
Pre-release
Added orderByValues
:
$query = $select
->field('t1.name')
->from('t1', 'test1')
->where('t1.id IN (?)', [5, 1, 66, 183, 99, 2, 6])
->orderByValues('t1.id', [5, 1, 66, 183, 99, 2, 6])
->asString();
SELECT
t1.id
FROM
test1 t1
WHERE
t1.id IN ('5', '1', '66', '183', '99', '2', '6')
ORDER BY
CASE `t1`.`id`
WHEN '5' THEN '0'
WHEN '1' THEN '1'
WHEN '66' THEN '2'
WHEN '183' THEN '3'
WHEN '99' THEN '4'
WHEN '2' THEN '5'
WHEN '6' THEN '6'
END ASC