phpbar.de logo

Mailinglisten-Archive

MySQL Select Statement

MySQL Select Statement

Georg Richter mysql-de_(at)_lists.bttr.org
Thu, 23 May 2002 22:27:27 +0200


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 



php::bar PHP Wiki   -   Listenarchive