How to get data that contains a specific dynamic value?
I am trying to get data based on search input using .contains but I get an error.
I tried .ilike and it works but only if I search for the entire name, which is not what I am looking for, not some part of it e.g the first 3 letters
I tried .ilike and it works but only if I search for the entire name, which is not what I am looking for, not some part of it e.g the first 3 letters