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?
Did you know that, in addition to the forum, Laracasts includes well over 1000 lessons on modern web development? All for the price of one lunch out per month.