MySQL Select Statement

[Georg Richter]

On Thursday, 23. May 2002 21:48, cael_(at)_mahold.de wrote:
Hi!

>
> SELECT * FROM table WHERE (a+b+c) = D;
>
> i.e.:
> a = 5
> b = "text"
> c = "text"
> D = "5texttext"

Yes, its possible but for strings you need the concat function:
SELECT * FROM table where concat(a,b,c) = d;

See http://www.mysql.com/doc/S/t/String_functions.html

Regards

Georg

---
Infos zur Mailingliste, zur Teilnahme und zum An- und Abmelden unter
-->>  http://www.4t2.com/mysql