Big Bird
06/11/2022, 7:38 AMconsole.log('getOneJobFromDb', jobAddress)
let { data, error } = await supabase
.from('jobs')
.select('*')
.ilike('address', jobAddress) // using ilike to manage case-insensitive search
if (error) {console.log('eerrrororor', error)}
console.log('DATA',data)
I expect to receive ONE hit. Because when I copy paste the value of jobAddress
into the filter in the table exploration of app.supabase.com, it yields the expected result:Needle
06/11/2022, 7:38 AMgaryaustin
06/11/2022, 1:00 PMBig Bird
06/12/2022, 8:31 AMNeedle
06/13/2022, 7:04 AM