Where clause compare column of table
Author: bohrasankalpCreated Oct 1, 2023Updated May 29, 2025
The update query is
UPDATE videos v SET channel = $1 FROM channels c WHERE c.channel_id = $2 AND v.channel_id = $3
Builder
var channelID int
query, args, _ := sq.Update("videos v").Set("channel", "c.id").From("channels c").
Where(sq.Eq{"c.channel_id": "v.channel_id", "v.channel_id": channelID}).PlaceholderFormat(sq.Dollar).ToSql()This makes args as "c.id" & "v.channel_id" and actually compares string
Source: Masterminds/squirrel