MySQL Forums
Forum List  »  Knowledge Base

Complicated query help!
Posted by: Andy Buchan
Date: January 06, 2010 04:24PM

I have a database table which has 4 translations in it. I want to select all the entries with a particular ID and replace all the entries for another. I've tried several different was with no luck. Can anyone help me??

In a query this is kind of what i'm trying to do:

SELECT * FROM `tblTranslation` WHERE `LanguageID` = 1 REPLACE * WHERE `LanguageID` = 2 [with the data from the first part of this query]

Hope that makes sense, any help is greatly appreciated!

Options: ReplyQuote

Written By
Complicated query help!
January 06, 2010 04:24PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.