MySQL query help required

ripefruit

I want to insert a number into field #2 if a number in field #1 matches x

Both fields are in the same table in the same db.

field 1 = CatParent
field 2 = CatParent2

What query do I run to effect this?

mwasif

Do you want to update existing records or insert new records into the table?

ripefruit

Its an existing field that I want to enter for a record that I want to enter data for..

If 'record' CatParent = 20 insert into CatParent2 = xyz

There will be multiple records that CatParent will = 20

mwasif

Then you need an UPDATE query. The query will look like

Expand|Select|Wrap|Line Numbers

 UPDATE table_name SET

CatParent2 = 'xyz'

WHERE CatParent = 20

Test this query on a test data before executing on real databse. It is always wise to backup your database before experiments :)

ripefruit

Worked like a dream... huge thanks mwasif!

MySQL query help required

re: MySQL query help required

re: MySQL query help required

re: MySQL query help required

re: MySQL query help required

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about