problem with combining text values

[Free WordPress Themes]

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?

[Free WordPress Themes]

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.

[Free WordPress Themes]

maybe this is a good example for the snippet library:

a similar function like:

Code:

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

[Free WordPress Themes]

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

In this case we need a new code type : mysql

[Guest]

[36.904]

Yahoo crawler, Googlebot, Baidu Spider