Perfect. '%'+dcp.titleslug+'%' Only returned 296 potential matches. So much for my hopes of automating the merge operations. :(
On Wed, Jul 23, 2008 at 12:17 AM, James Holmes <[EMAIL PROTECTED]> wrote: > Oh I get the problem now (my bad). > > This works in Oracle: > > select dcp.title, cdb.title > from gcd cross join cdb > where cdb.titleslug like '%'||dcp.titleslug||'%' > > || is the string concatenation operator in Oracle; try the appropriate > one for your DB. > > > On Wed, Jul 23, 2008 at 11:20 AM, Michael Dinowitz > <[EMAIL PROTECTED]> wrote: > > I tries > > select dcp.title, cdb.title > > from gcd cross join cdb > > where cdb.titleslug like %dcp.titleslug% > > > > This is on SQL 2000 and I got: > > error in where clause near '%' > > unable to parse query text. > > > > As for speed, we're talking about 80,000 titles to match between 7 > databases > > on a dedicated CF enterprise home test box. It can run all night if it'll > > work. :) > > > > > > On Tue, Jul 22, 2008 at 11:04 PM, James Holmes <[EMAIL PROTECTED]> > > wrote: > > > >> "Something like where dcp.titleslug like %cdb.titleslug%" > >> > >> That's pretty much what I'd do in this situation (although it will run > >> slow) - is it not working? > >> > >> On Wed, Jul 23, 2008 at 10:04 AM, Michael Dinowitz wrote: > >> > I'm doing a join of two tables where each has a title-slug (a string > with > >> > all non-alphanumeric characters converted and dashes between words). > I'd > >> > like to do a like join between the two title slugs but don't know how > to > >> do > >> > it with non-variable data. Something like > >> > where dcp.titleslug like %cdb.titleslug% > >> > > >> > the dcp titleslug will be somewhere in the cdb.titleslug > >> > > >> > any ideas? > >> > >> -- > >> mxAjax / CFAjax docs and other useful articles: > >> http://www.bifrost.com.au/blog/ > >> > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3104 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
