JavaScript operator similar to SQL “like”

Question

I have this function with jquery, but I need it to work like operator "like" Help me. Thank you very much for your help

works correctly if I look the whole word example

var vsearch = "home"  
var array = _.filter(objeto, function(product){ 
return product.filtro ==vsearch;

var vsearch=`H`
var array = _.filter(objeto, function(product){ 
return product.filtro ==vsearch;

No looks for containing the H

Thanks.

in the filter can't you use the various string functions like `indexOf`? — Danny, Jun 09 '14 at 18:16
Yeah, you can do `return product.filtro.indexOf(vsearch) > -1;` inside the filter to only get products that contain vsearch. — Ryan Erdmann, Jun 09 '14 at 18:18

score 3 · Accepted Answer · answered Jun 09 '14 at 18:19

3

Use indexOf, which returns -1 if a string is not found, to see if the product contains the letter you're searching for.

var vsearch=`H`;
var array = _.filter(objeto, function(product){ 
   return product.filtro.indexOf(vsearch) > -1;
}

answered Jun 09 '14 at 18:19

Ryan Erdmann

1,786
10
11

1

additionally if you want it to be case insensitive you can do `.toLowerCase()` to both strings. – Danny Jun 09 '14 at 18:21
thank you very much worked correctly – Daniel Jun 09 '14 at 21:54

score 0 · Answer 2 · answered Jun 09 '14 at 18:19

0

You could try something like this:

var stringToSearch = "The full string to search goes here";
var searchTermContains = stringToSearch.search("H");

This will return a -1 if no match is found.

answered Jun 09 '14 at 18:19

mwilson

12,295
7
55
95

JavaScript operator similar to SQL “like”

2 Answers2