problem with combining text values

Hi,

I trying to use to update a field with to pieces of text:

Code:

UPDATE `plaatsnamen` SET tmp_plaats = SUBSTRING(tmp_plaats, 1, 1) LCASE(SUBSTRING(tmp_plaats FROM 2))

but how to put them together? make it one string?

got it:

UPDATE
`plaatsnamen`
SET
tmp_plaats = CONCAT(SUBSTRING(tmp_plaats, 1, 1), LCASE(SUBSTRING(tmp_plaats FROM 2)));

[Join us @ facebook]

That was fast.

BTW CONCAT can be used with more than one elements, and it is very good for UPDATE's and INSERTS, but very slow in queries in WHERE statements.

maybe this is a good example for the snippet library:

a similar function like:

Code:

<?php
ucfirst(strtolower("HELLO WORLD"));

maybe this is a good example for the snippet library:
...

In this case we need a new code type : mysql

[Guest]

[62.861]

Googlebot, jarankepang, Yahoo crawler