Problem with mysql like operator with Django

2009-07-05 Thread newbie
Hi, In my view, I connected to the mysql server using the cursor object. I tried to execute the following query: select pincode from pincode where state='Andhra Pradesh' and district='Nellore' and area LIKE '%road%' or '%item%'; The above query is perfectly working when i give it on the mysq

Re: LIKE operator

2006-03-19 Thread PythonistL
Ivan, Thank you for your reply and help L. --~--~-~--~~~---~--~~ 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, sen

Re: LIKE operator

2006-03-18 Thread Ivan Sagalaev
PythonistL wrote: >Is LIKE operator supported in Django? > >I would like to perform a pattern match. > >For example something like this: > >SELECT name FROM metal WHERE name LIKE '%er%', > > metals.get_list(name__contains='er') --~--~

LIKE operator

2006-03-18 Thread PythonistL
Is LIKE operator supported in Django? I would like to perform a pattern match. For example something like this: SELECT name FROM metal WHERE name LIKE '%er%', where name is a field of table . That above will return results that contain 'er' anywhere in a fie