Joining 2 tables on part information in fields

[mpc123]

Hi I am trying get a query to join 2 tables and a result on the information in both. At the moment I have the following

$query = "SELECT * FROM TABLE1, TABLE2 Where 'TABLE2.field1' LIKE '%TABLE1.field2%'";

The problem is TABLE2 has a field with names in but TABLE1.field2 has |name|name|name| and so on. |=TAB

So im struggling for the query to find a match in there somewhere.

Can anybody suggest anything please

Thanks

[pritaeas]

It's a shame you use tabs. If you use comma's instead you'd be able to use FIND_IN_SET() (assuming you use MySQL).

[mpc123]

I can change it to commas, so how would work with FIND_IN_SET() please

[pritaeas]

http://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_find-in-set

... WHERE FIND_IN_SET(table2.field1, table1.field2)

[mpc123]

wow thanks thats great, will try it now

[mpc123]

Hi

I have changed to comma rather than tab and the query now works perfect, thanks for your help