Join two columns into one

[Shaolin]

Hi Guys

I have a table called user which has the first_name and last_name in 2 columns. I want to carry out searches on the complete name but I need a way to join the two columns together. Does anyone know how I can do this ?

[chazzy]

does your dbms support full text search? what about the concat function?

[Shaolin]

I dont know. Im using mysql. Im not aware of any inbuilt search features ..

[chazzy]

well i think you should look up full text search, as i think it's what you want.