Query from 2 tables

[mikawhat]

I have a question, if it's possible actually to do something...

e.g. $query = "SELECT tbl1.* FROM tbl1, tbl2 WHERE tbl1.field1=tbl2.field1";

taking the tbl1.field1=tbl2.field2, i need something like tbl1.field1 LIKE '%tbl2.field1%'

could that return some results?

[nemonoman]

It will work just fine. Might be slow.

[mikawhat]

Any suggestions then?

[nemonoman]

Index tbl1.field1

If the tables are little, i.e, under a few hundred rows each, you probably won't even notice a change from an index, and it would just be more overhead.

[mikawhat]

OK. i could do that after i get it to work... the problem is that the query is not working at the moment...i need something like tbl1.field1 LIKE '%contents of tbl2.field1%' ... so how you 'translate' contents of tbl2.field1 for mysql query?

[Lars_Berg]

tbl1.field1 LIKE concat('%',tbl2.field1,'%')

An index will not improve performance for this query.