[SOLVED] what is the correct sql statement for this

[mga_ka_php]

select concat(column1,column2) as column3 from table1 where column3 like '%$str%'  ???????

 

coz i want to search in a concatenated column, how do i do that?

[Barand]

select concat(column1,column2) as column3 from table1 where concat(column1,column2) like '%$str%'

 

 

You can't use an alias in a WHERE clause

[fenway]

But you can using it a HAVING clause... and sometimes you can.

[mga_ka_php]

wow thanks.