How to take the first letter and insert it in another field

[hoverinc]

Hello everybody, I am trying to insert in the letter field the first letter of the FILEDX's content, How can i do it???

 

 

Any ideas is most appreciated, thanks

 

[awjudd]

Use mysql's LEFT function (http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_left)?

 

~judda

[hoverinc]

Use mysql's LEFT function (http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_left)?

 

~judda

 

 

THANKS Juddster, i have checked that and worked

 

SELECT LEFT(names, 1)from test

 

Now i will to find out how to insert it again to it's corrisponding field using UPDATE because the other fields contains data, if you have idea regarding during my checkup i would be thankful. 

[ManiacDan]

There's nothing else we can tell you aside from writing the query for you.

UPDATE someTable SET field2 = LEFT(field1, 1);

 

Also, there's no reason to ever do this, you're duplicating data and you'll only make it hard on yourself.

 

-Dan

[hoverinc]

Use mysql's LEFT function (http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_left)?

 

~judda

 

AND ALSO i found this

SELECT SUBSTRING(FIELD,1,1)

do a similar thing

[hoverinc]

There's nothing else we can tell you aside from writing the query for you.

UPDATE someTable SET field2 = LEFT(field1, 1);

 

Also, there's no reason to ever do this, you're duplicating data and you'll only make it hard on yourself.

 

-Dan

 

Thanks that worked perfectly

[hoverinc]

I noted that this code is giving me error, any ideas is appreciated

 

DELETE * FROM TABLE WHERE catid !='40'

 

or may be i am missing some commands related

[awjudd]

DELETE FROM TABLE WHERE catid != 40

 

There is no such thing as DELETE * FROM ...

 

~judda

[hoverinc]

DELETE FROM TABLE WHERE catid != 40

 

There is no such thing as DELETE * FROM ...

 

~judda

 

Yes, corrected it and worked, thanks