Results 1 to 7 of 7
Jul 23, 2012, 14:56 #1
Help writing a mySQL query - Matching a column from one table to a column in another
I am attempting to write a query that matches a titles of some material I have in a database to a list in another table of authors, and then spit out the results. The issue is that sometimes the author name may be along the lines of CJ, C.J. or C J Watson, so its impossible to get an exact match all of the time.
Any ideas how I could match up the data from the author tables to match the data in the title fields?