mysql insert select

[coolR]

Generally mysql does

INSERT INTO user (id, name, email, passwd, site) SELECT idm, user_name, email, pass, site_url FROM members WHERE id>100 AND id<200

But I want a query where `site` column of user table will insert a static string fixed my me, not from `members` table

something like
(just for easy to understand)

INSERT INTO user (id, name, email, passwd) SELECT idm, user_name, email, pass FROM members WHERE id>100 AND id<200, SET site='my fixed site url'

[swampBoogie]

insert into user (id, name, email, passwd,site) 
select idm, user_name, email, pass, 'my fixed site url'
  from members 
 where id > 100
   and id < 200

[guido2004]

It's easier than you think

INSERT INTO user (id, name, email, passwd, site) 
SELECT 
    idm
  , user_name
  , email
  , pass
  , 'my fixed site url'
FROM members 
WHERE id>100 
AND id<200

Swampboogie was quicker..