Can one copy first letter of field to another field

[jerijeri]

HI,

I'm wondering if there's a MySQL command/function to copy the first letter of one field to another field.

Thanks,

Jer

 

[QatQat]

Insert into table1(field1, field2) values
('value1', substring(field1, 1, 1));


This will fill in the second column with the first letter of the value inserted in the first column.


Bye

Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[jerijeri]

Thank you. I had tried UPDATE with SUBSTRING(field_name,1,1) with no success. Will try this now.

Jer

 

[jerijeri]

No luck with your suggestion. I should have made it clear that the data is in the table and isn't an insert. This is what I've tried.

UPDATE table SET field_2 = substring(field_1,1,1)

I'm not sure why this wouldn't do what I want.

Jer

 

[swampBoogie]

That query should be ok. What happens?

 

[jerijeri]

UPDATE table SET field_2 = substring(field_1,1,1)

updates 1 record. If I try

UPDATE table SET field_2 = substring(field_1,1,1) WHERE id > 1

it updates none. I can't figure what's happening. The field I'm update is set to CHAR(1) and the data it's reading from are all letters.

Jer

 

[jerijeri]

Well, I found the problem. The query I originally used was fine. I changed

UPDATE table SET field_2 = substring(field_1,1,1)
to
UPDATE table SET field_2 = substring(field_different,1,1)

and it looked just as it should. When I exported the data, I saw a \n as the first character for the field I was trying to import. This was the case except for the very first record.

Jer