I do not know. I generally do not pay attention to that. Right now, I am using SQL profiler to find long running queries. If I find one good, I will let you know. ;-)
-----Original Message----- From: G Money [mailto:[email protected]] Sent: Tuesday, June 23, 2009 10:06 AM To: cf-community Subject: Re: I need a drink What's the wildest search term you've seen, Jacob? On Tue, Jun 23, 2009 at 11:58 AM, Jacob wrote: > > ... or two. Have to be kidding me! > > > Search term: 90 all naturals > > The query: > > Select Top 1000 * From > > DVD > > > Where ( Stock = '90 all naturals' > OR ( > Subtitle like '%90 all naturals%' > > OR REPLACE(Subtitle, '''', '') like '%90 all > naturals%' > or Subtitle like '%90 all naturals!%' > OR REPLACE(Subtitle, '''', '') like '%90 all > naturals!%' or Subtitle like '%90_all_naturals%' > OR REPLACE(Subtitle, '''', '') like > '%90_all_naturals%' or Subtitle like '%90_all_naturals%' > OR REPLACE(Subtitle, '''', '') like > '%90_all_naturals%' or Subtitle like '%90 all naturals!%' or Subtitle like > '%90 all%' > ) > OR Title like '%90 all naturals%' > OR REPLACE(Title, '''', '') like '%90 all naturals%' > > or Title like '%90 all naturals!%' > OR REPLACE(Title, '''', '') like '%90 all > naturals!%' or Title like '%90_all_naturals%' > OR REPLACE(Title, '''', '') like '%90_all_naturals%' > or Title like '%90_all_naturals%' > OR REPLACE(Title, '''', '') like '%90_all_naturals%' > or Title like '%90 all naturals!%' or Title like '%90 all%' > or Title like '%90: all naturals %' > > or Title like '%90? all naturals %' > > or Title like '%90! all naturals %' > > or Title like '%90 all: naturals %' > > or Title like '%90 all? naturals %' > > or Title like '%90 all! naturals %' > > or Title like '%90 all naturals: %' > > or Title like '%90 all naturals? %' > > or Title like '%90 all naturals! %' > OR Title like '%90%' > OR Title like '%90 all%' > OR Title like '%90 all naturals!%' > > ) > AND url like '%.%' > order by Rating DESC, Title > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:298831 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
