Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by mmoutadayne
-
MySQL text matching
Thanks for your help... looks like I'll have to add TRIM. My DB admin is on vacation so i have to do this solo [thumbsdown]. If anyone has any ideas i'd love to hear them Sincerely, Mohamed- mmoutadayne
- Post #5
- Forum: MySQL
-
MySQL text matching
Thank-you for the prompt reply. I should have posted the query that i had come up with in my original post because that is the same one :-)... I guess what i want to know is if there is another way that might be faster because this query ran for well over a day before it crashed! Thank-you...- mmoutadayne
- Post #3
- Forum: MySQL
-
MySQL text matching
Hello All, I have a table of ~5,000,000 records (ID, name, title) and a second table of ~2,000,000 records (ID, name, title). What i need to do is return the ID's from the first table where there is no exact match with a name/title in the second table. So if a row in table 1 is (3, Tom...- mmoutadayne
- Thread
- Replies: 4
- Forum: MySQL
