The queryset's extra() method can help you with that:
MyModel.objects.extra(where=["replace(db_column_name, '''', '') = %s"],
params=["rockn burger"])
(Be careful if you're typing that in manually -- there are lots of
single-quotes in it)
Ian
On Fri, Jul 20, 2012 at 4:02 PM, Ada Pineda <[email protected]> wrote:
> Hello
>
> I'm asking for your help because I need to do a query on a table that has
> a field that contains apostrophes, but I need to ignore them (apostrophes)
> when I'm doing the query. I have to save the data as it is, so I can't just
> take away those apostrophes before saving to the database. I mean, if the
> database has "rock'n burger" and a user types "rockn burger", I need to get
> the value with apostrophe from the database.
>
> Can anyone help me?
>
> Thanks a lot!
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/django-users/-/lxGzVjrwQgMJ.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.
>
--
Regards,
Ian Clelland
<[email protected]>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
