Filter JSON data by using LIKE operator as in SQL

Hi All,

I have below json data.

I want to filter using url and yyyy_mm column and create the new data in json format.

I have 2 requirements here:-

1). Filter using url column using like operator in sql.
suppose if i pass url as yahoo.com then it should return me all data which contains yahoo.com such as yahoo.com/sites/player,yahoo.com,yahoo.com/sites/mlo/sdfc and so on.

2). filter using url and yyyy_mm column. So in this case whatever matching rows should be returned.
Please note that :- it should return me json object.

var tempData =[{"url":"http://google.com","yyyy_mm":"2017-12","skills":"C#","count":3},                    {"url":"http://google.com","yyyy_mm":"2017-11","skills":"F#","count":4}
{"url":"http://google.com/sites/player","yyyy_mm":"2017-10","skills":"asp.net","count":4},               {"url":"yahoo.com","yyyy_mm":"2017-12","skills":"vb.net","count":10},
{"url":"yahoo.com","yyyy_mm":"2017-11","skills":"vb.net","count":5},
{"url":"yahoo.com/sites/player","yyyy_mm":"2017-11","skills":"vb.net","count":6},
{"url":"yahoo.com/sites/mlo/sdfc","yyyy_mm":"2017-11","skills":"vb.net","count":10},
{"url":"yahoo.com/fast/doc","yyyy_mm":"2017-10","skills":"vb.net","count":11},
{"url":"yahoo.com","yyyy_mm":"2017-10","skills":"json","count":100}]

Thanks in Advance!!!!!