I am trying to run a query using Eloquent the $vars['language'] is in lower case but the language column is not necessarily in lower case. How can i do this search using eloquent but still have the lower case in the query
Item::where('language', $vars['language'])
What i want to do is this even though i can't find anywhere how to do this
Item::where('LOWER(language)', $vars['language'])
so that they are both in lowercase and then i can get them to match.
See Question&Answers more detail:os