I would suggest trying to get the change, the most they can say is no. Else you are going to have to do some removing of characters something like this may work
file = http:/www.yoursite.com/images/123.gif Select * from some_table where REPLACE(REPLACE(url_field,'http:/www.yoursite.com/images/',''),'.gif','') = 123 -----Original Message----- From: Todd [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 07, 2004 9:23 AM To: CF-Talk Subject: Re: MySQL query question A couple of reasons. 1. This wasn't thought about ahead of time and there is several months worth of data in the table already. 2. I have no control over the database. This makes for a bad combination :) So. I have to work with what I have. ----- Original Message ----- From: "Eric Creese" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 07, 2004 10:08 AM Subject: RE: MySQL query question > 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186463 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
