Error while using like statement in django raw sql

Question

I have a raw sql query which is always giving error while executing. Here is my query

Users.objects.raw('select target, username from users where location like \'%s%%\' and date(modified) = \'2011-06-14\'',[location])

I am taking the location = 'BUILD'

Location values would be 'BUILD_A', 'BUILD_B','BUILD_C'.

When I am executing the raw sql, below is the error I am getting.

DatabaseError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BUILD'%' and date(modified) = '2011-06-14'' at line 1")

In MySQL terms I need to execute the following query:

Select target, username from users where location like 'BUILD%' and target = '2011-06-14'

I have googled it but could not able to get it. Please some one help me

Vikram · Accepted Answer · 2011-06-16 08:49:15Z

9

I have solved my problem in this way.

location = location + '%'

users_list = Users.objects.raw('select target, username from users where location like %s and date(modified) = %s',tuple([location,date]))

The above statement executes perfectly without any error and I can able to render the results in template also.

answered Jun 16, 2011 at 8:49

Vikram

7,58318 gold badges87 silver badges131 bronze badges

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

1 Comment

Jason Champion Over a year ago

Thank you, that's such a simple solution to make LIKE and ILIKE queries work in raw.

Amit Baderia · Accepted Answer · 2019-02-06 05:44:04Z

-1

Below query works for me,

query = "Select target, username from users where location like 'BUILD%'"
results = Users.objects.raw(query)

answered Feb 6, 2019 at 5:44

Amit Baderia

4,9524 gold badges31 silver badges20 bronze badges

Collectives™ on Stack Overflow

Error while using like statement in django raw sql

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related