search

adonisjs / lucid

AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more
https://lucid.adonisjs.com/
MIT License
1.02k stars 189 forks source link

whereILike Not Working #1031

Open mohitxskull opened 1 month ago

mohitxskull commented 1 month ago

Package version

20.1.0

Describe the bug

query.where('name', 'ILIKE', `%${payload.params.name}%`) // Working as expected
query.whereILike('name', `%${payload.params.name}%`) // Not working

Reproduction repo

No response

thetutlage commented 1 month ago

How do you verify its not working? And we will need a reproduction before we can check if it is indeed a bug.