Have you tried:
select concat("blah", x, "bleh") from y group by x;
> Hi All,
>
> when I use a distinct on varchar fields, does mySQL truncate the value
> of the string to some set value.
> This two queries give me a completely different number of rows an
Hi All,
when I use a distinct on varchar fields, does mySQL truncate the value
of the string to some set value.
This two queries give me a completely different number of rows and I am
not sure how to influence the behaviour:
select distinct x from y; (many rows result)
and
select distinct
