public function getSystemUsersByPhone($phone)
{
return $this->user->whereRaw("REPLACE(`phone`, ' ' ,'') LIKE ?", ['%'.str_replace(' ', '', $phone).'%'])->first();
}
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter