manhattes Posted February 4, 2016 Share Posted February 4, 2016 I have 2 tables Table1 is names,addresses,phone Table2 has other info that i want including the names In table2 the names are in a cell grouped together like this: James Madison|University of Iowa|Jeff Hall What is the best way to join the table since there is no exact match? Is it a str_search or something? Quote Link to comment Share on other sites More sharing options...
Jacques1 Posted February 4, 2016 Share Posted February 4, 2016 The best way is to repair your database design and store the data in a normalized manner. One field is for one piece of data. When the layout is so broken that you can't even do a simple join, it's definitely time for a fix. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.