I want to use DISTINCT COUNT in rel.Select, how can I do that?

[hxgdzyuyi]

	type UvDictRow struct {
		Adid      string
		AdidCount int
	}
	var uvDictRows []UvDictRow
	err = repo.FindAll(
		ctx,
		&uvDictRows,
		rel.Select("adid", "COUNT(DISTINCT userid) as adid_count"),
		rel.From("log_visits").Group("adid"),
		where.Eq("plan_id", plan_id),
	)
	if err != nil {
		return
	}

*mysql.MySQLError=Error 1054: Unknown column 'log_visits.DISTINCT userid' in 'field list', string=args, []interface {}=[[26]])
{"error": "Error 1054: Unknown column 'log_visits.DISTINCT userid' in 'field list'"}

[Fs02]

seems this is no documented yet, but you can avoid escaping the field by using ^ prefix, example:

rel.Select("adid", "^COUNT(DISTINCT userid) as adid_count"),

[hxgdzyuyi]

thanks