Hi,
Try this:
select * from table1,table2 where table1.column1 like
concat(table2.column2,'%');
Anvar.
At 04:57 PM 20/02/2002 +, you wrote:
>>mysql,query
>>
>>
>>Hi , is there any way of performing something like the below statement?
>>
>>select * from table1,table2 where table1.column1
>
>mysql,query
>
>
>Hi , is there any way of performing something like the below statement?
>
>select * from table1,table2 where table1.column1 like table2.column2
>
>thanks in advance
>
>Rich
-
Before posting, please check: