I am trying to use the
firstOrNew Eloquent methods to find a record in the database by a column in a given table. I'd like to use the
like MySQL operator to search for records that do not 100% match the current entry. From what I can tell, these methods only allow for the column and the value with no special operators. Is there a way to use these methods how I have described?
Here is an example of what I would like to do (does not work currently)
$dma = Dma::firstOrCreate( ['name', 'like', "%$market%"] );
The above code produces the following error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column '0' in 'where clause' (SQL: select * from
0= name and
1= like and
2= %Market%) limit 1)
I understand that this error occurs because the array is not formed properly for the firstOrCreate method, but is there a way to make this work or an alternative that will accomplish what I am looking to do?