why would you not store the id in the second table as a FK to the PK in table one. I think that is just good table design and will easily accomplish what you are trying to do and will more than likely return your results much faster.
-----Original Message----- From: Todd [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 07, 2004 8:47 AM To: CF-Talk Subject: MySQL query question In one table I have an ID as the primary key. In a second table, I have a string that is made out of that ID. I'm trying to match the two. The string looks like this: /folder1/folder2/some_other_stuff_that_changes/123.txt where 123 is the ID from the first table. How can I match the two using SQL? I'm trying to get a list of all of the IDs that do not have a url associated with them. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186453 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
