db.tablename.fieldname.contains('whatever')
On Saturday, 25 April 2015 10:28:10 UTC-5, Tom Stratton wrote:
>
> Hi -
>
> I'm struggling to find a way to do an "ilike" style search within a list
> of strings field in the db.
>
> For example, my field may contain ['Donald Duck', 'Minnie Mouse']
>
> I'd like that record returned when I am searching for '%mouse%'
>
> Maybe I need to cast the list to a string but this is just part of a
> larger query and I'm hoping for a simpler, built in, solution.
>
> Thanks
>
> Tom
>
> PS - what does it take to get posting permissions? I feel like I would
> participate more if my answers didn't get help overnight ;-)
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
