Concatenating a MySQL Query 2

[monkey64]

I have the key phrase "Monkey Nuts" that I want to search for.
I have two fields:
In field [animal] I have a value "Monkey"
In field [food] I have a value "Nuts"

I want to search a table for [animal] + ' ' [food], so it returns "Monkey Nuts".

So I tried:

$query = "SELECT * FROM mytable WHERE (animal, + ' ' + food) = 'Monkey Nuts'";

It doesn't work. What am I doing wrong?

 

[DonQuichote]

Use either the string concatenator (||) or the CONCAT function. But beware:
- the standard string concatenator is by default seen as a boolean OR if you do not configure the server to adapt the standards (ANSI mode).
- concatenating any field with value NULL will cause the result to be NULL. Use the IFNULL function if you want the concatenation of an empty string in such a case.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)

 

[vacunita]

SELECT * FROM mytable WHERE CONCAT(field1,' ',field2) = 'Monkey Nuts'

----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[monkey64]

Thanks to DonQuichote and vacunita.
The function CONCAT was what I needed and you both guided me in the right direction. Easy when you know how!

Thanks again.