search for text within string in laravel or mysql

I use my SQL as backend for my project, and I need to get all record from database where some part of inputted string is available in database string like:

table = seller

id  company_name  seller_name
1   companyname1  seller1
2   companyname2  seller2
3   companyname3  seller3
4   companyname4  seller4

Given string is 1105 companyname1 is outstanding

So i need to get id = 1 for a given string if it is possible with laravel or MySQL then please help me.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2uuFkUr
via IFTTT