[SOLVED] merging mysql table fields

[prakash]

How can I merge multiple fields of a table for my query.

 

suppose I have 2 table

 

table1

=============

field1      field1

=============

Lam        20

Ld            9

Auz          3

 

so I want to check where does keyword "Ld9" Exisit

 

so what will me my query for

select * from table1 where field1+field2=$keyword

[Rithiur]

Use the concat function like

 

SELECT * FROM table1 WHERE CONCAT(field1, field2) = "Ld9"

[prakash]

well that works

 

thanks for the help