Re: Anal not Analog, Analysis: DB Question

[Tom Smith]

On 4 Oct 2006, at 17:09, Andy Dustman wrote: On 10/4/06, Tom Smith <[EMAIL PROTECTED]> wrote: If I am looking for titles like "Anal Sex" or "Being Anal" then how do I construct this, ahem, query... to not return "Analysis" or "Analog"? Two options: If your database supports it, try a full-text search: object_list = Products.objects.filter(title__search=word) Another option: MySQL at least has a REGEX search. To use it: object_list = Products.objects.extra(where=["title REGEX %s"], params=[r"\b%s\b" % word]) Above is untested in Django, but it should be what you want. \b matches word boundaries. I found this...  Note that on darwin, the dbexclude feature will not work due to word boundary anchor bugs in regex. ....here... http://dev.mysql.com/doc/refman/5.0/en/check-table.html ...bugger! So to speak...  I also found that your code was missing a "P"... REXEXP...  as a workaround for now... this kinda works... object_list = Product.objects.extra(where=[r"title REGEXP %s"], params=[r"(^%s | %s[ $])" % words] ) Thanks for the help Andy...  tom --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---