shergar1983 Posted June 25, 2008 Share Posted June 25, 2008 Guys, This is embarassing and has been bouncing round the office all day. The example: table1.field1 has first names and middles names e.g. Edward Martin. table2.field1 has just first names e.g. Edward. I need to have a select join which shows all those records where table1.field1 contains table1.field1. It is this type of join I am trying to solve rather than a different approach to the example which is ficticious. Any help would be much appreciated. Link to comment https://forums.phpfreaks.com/topic/111875-select-from-table1table2-where-table1field1-like-table2field1/ Share on other sites More sharing options...
fenway Posted June 25, 2008 Share Posted June 25, 2008 You can use wildcards to join 2 tables, it's just not efficient. Link to comment https://forums.phpfreaks.com/topic/111875-select-from-table1table2-where-table1field1-like-table2field1/#findComment-574352 Share on other sites More sharing options...
shergar1983 Posted June 25, 2008 Author Share Posted June 25, 2008 oh okay, any suggestions? I can't think of any... Link to comment https://forums.phpfreaks.com/topic/111875-select-from-table1table2-where-table1field1-like-table2field1/#findComment-574487 Share on other sites More sharing options...
fenway Posted June 26, 2008 Share Posted June 26, 2008 Not really -- inexact matches are poor to begin with. Why is your data stored this way? Link to comment https://forums.phpfreaks.com/topic/111875-select-from-table1table2-where-table1field1-like-table2field1/#findComment-574738 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.