Дали може?
6 отговора
247 прегледа
Дали може?
исма ми се да напиша нещо такова на MySQL:
SELECT @t:= concat(firstname," ", lastname)
FROM table1
WHERE @t LIKE "%ен Ива%" OR @t LIKE "%сто Петр%"
или
SELECT concat(firstname," ", lastname) AS t
FROM table1
WHERE t LIKE "%ен Ива%" OR t LIKE "%сто Петр%"
обаче и двете не работят
някаква идея какво мога да направя?
Предварително благодаря!
SELECT @t:= concat(firstname," ", lastname)
FROM table1
WHERE @t LIKE "%ен Ива%" OR @t LIKE "%сто Петр%"
или
SELECT concat(firstname," ", lastname) AS t
FROM table1
WHERE t LIKE "%ен Ива%" OR t LIKE "%сто Петр%"
обаче и двете не работят
някаква идея какво мога да направя?
Предварително благодаря!
Re: Дали може?
NOTE: In a SELECT statement, each expression is only evaluated when it's sent to the client. This means that in the HAVING, GROUP BY, or ORDER BY clause, you can't refer to an expression that involves variables that are set in the SELECT part. For example, the following statement will NOT work as expected:
SELECT (@aa:=id) AS a, (@aa+3) AS b FROM table_name HAVING b=5;
The reason is that @aa will not contain the value of the current row, but the value of id for the previous accepted row.
imai go v predvit tova
SELECT (@aa:=id) AS a, (@aa+3) AS b FROM table_name HAVING b=5;
The reason is that @aa will not contain the value of the current row, but the value of id for the previous accepted row.
imai go v predvit tova