Multiple arguments in MySQL raw() query in DJango-Python

Question

I need to find a person when he enters his mobile number or email in the login form. My raw() query goes like this:

user = Users.objects.raw('SELECT * FROM main_users WHERE mobile  = %s OR email = %s',[login_id],[login_id])

But I am always getting a error:

Exception Value: not enough arguments for format string

So, what's the correct format for getting this solved?

alecxe · Accepted Answer · 2014-12-08 15:17:30Z

2

You should put parameters under the same list:

user = Users.objects.raw('SELECT * FROM main_users WHERE mobile  = %s OR email = %s',
                         [mobile, email])

answered Dec 8, 2014 at 15:17

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Daniel Roseman · Accepted Answer · 2014-12-08 15:19:51Z

2

There is no need for a raw query here.

users = User.objects.filter(Q(mobile=login_id) | Q(email=login_id))

answered Dec 8, 2014 at 15:19

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

proxima · Accepted Answer · 2014-12-08 18:27:58Z

0

You can do this by any of these two ways as already said above:

from django.db.models import Q
users = User.objects.filter(Q(mobile=login_id) | Q(email=login_id))

or by using raw() method:

user = Users.objects.raw('SELECT * FROM main_users WHERE mobile  = %s OR email = %s',[login_id,login_id])

answered Dec 8, 2014 at 18:27

proxima

3132 silver badges15 bronze badges

shawon · Accepted Answer · 2018-08-13 07:15:15Z

0

The upper solutions were not working for me. I solved by this in Python 3

user = Users.objects.raw("SELECT * FROM main_users WHERE mobile  = '%s' OR email = '%s' " %(mobile, email))

answered Aug 13, 2018 at 7:15

shawon

1,0328 silver badges15 bronze badges