The select function is used for filtering, @c represents taking from the first member onward until the first member that makes the condition false. The pos function returns the position of the ...

Is it possible to order by a substring in a returned field?I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...