RE: [midgard-user] Repliguard - the saga continues....

[Emiliano]

Tarjei Huse wrote:

> Is there a sql query I can use to find all id where sitegroup = 2 in my
> midgard db?
> i.e. _all_ the tables ??

Not directly, but

$ for t in article blobs element event eventmember file grp history host image member 
page pageelement pagelink person preference record_extension repligard snippet 
snippetdir style topic; do
> echo "select id from $t where sitegroup=2;" | mysql -u midgard -pmidgard midgard
> done

will.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]