What's the wildest search term you've seen, Jacob? On Tue, Jun 23, 2009 at 11:58 AM, Jacob <[email protected]> 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:298829 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
