Django raw query fails with ILIKE?

Asked May 14 '14 at 11:15

Active May 14 '14 at 11:15

Viewed 116 times

I have been going crazy trying to solve this. Any direction is appreciated .

I have the following sql query :

sql = "SELECT * FROM hotel_hotel h WHERE name ILIKE '%raffles%'"

I am trying to do :

Hotel.objects.raw(sql)

The % in "%raffles%" here is causing problems here. I am getting this error :

  TypeError: not enough arguments for format string

This doesn't happen when I do a ILIKE 'raffles'. Any workarounds for this ?

asked May 14 '14 at 11:15

Deepankar Bajpeyi

2

Possibly use double %. – Daniel Roseman May 14 '14 at 11:17
+1 to double %. '%' are interpreted as parameter, so you need to escape them. – I S May 14 '14 at 12:07

0 Answers0