MySQL Select Statement

[mysql-de_(at)_lists.bttr.org]

Hello,

i have a table like this:

CREATE TABLE table (
  a int(10),
  b char(20),
  c char(20)
);

Is it possible to create a select statement like the following one?

SELECT * FROM table WHERE (a+b+c) = D;

i.e.:
a = 5
b = "text"
c = "text"
D = "5texttext"

The result for the select statemen should be
SELECT * FROM table WHERE (5 + "text" + "text") = "5texttext";

thanx in advance
Rüdi

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