> Subject: [OT] SQL woes > It's at times like this I realise my SQL skills only cover the basics...
Mine too, but the problem could be that the '_' character in MySQL represents a single character wildcard, so it might be necessary to enclose your table and column names in backticks. > > I have two tables, 'user' and 'users_names'. I'm looking to deprecate > 'users_names', so I've altered 'user' to now contain a 'user_realname' > column. Both tables have a column 'user_id', which correspond to each > other. I'd like to take the data from 'users_names.name' and put it into > 'user.user_realname' where the 'user_id' column match. I just can't seem > to find the SQL to make MySQL do this. > > Any ideas? hth, d.