How to search an array in Jquery like SQL LIKE value% statement

Question

I have an array with some values. How can I search that array using jQuery for a value which is matched or close to it?

var a = ["foo","fool","cool","god","acl"];

If I want to search for c, then it should return cool but not acl.

How I can achieve that?

How is `c` close to `cool` but not to `acl` ? Do you want the word to start with `c` ? — XCS, Aug 28 '13 at 13:32
You can use regex as replacement for `value%` using `/^value.*/` — jcubic, Aug 28 '13 at 13:39

score 2 · Answer 1 · edited Aug 28 '13 at 13:39

2

Try this:-

arr = jQuery.grep(a, function (value) {
    search = /c/gi;
    if(value.match(search)) return true;
        return false;
    });

or

function find(arr) {
    var result = [];

    for (var i in arr) {
        if (arr[i].match(/c/)) {
            result.push(arr[i]);
        }
    }

    return result;
}

window.onload = function() {
    console.log(find(["foo","fool","cool","god","acl"]));
};

edited Aug 28 '13 at 13:39

Bart

17,070
5
61
80

answered Aug 28 '13 at 13:30

Rahul Tripathi

168,305
31
280
331

-1: jQuery? Where from? – Jon Aug 28 '13 at 13:30
1

@Jon: jQuery is right in the question title. And the question body. I've updated the tags. – Andrew Whitaker Aug 28 '13 at 13:31
Oh, right. Only looked at the tags, sorry. – Jon Aug 28 '13 at 13:32
Better `return !!value.match(search)` – jcubic Aug 28 '13 at 13:40
@jcubic:- Yes I agree but I think OP can modify this as per his/her need. This answer will give him/her enough hint!!! ;) – Rahul Tripathi Aug 28 '13 at 13:42

score 1 · Answer 2 · answered Aug 28 '13 at 13:32

Use substring to check if each string in the array begins with the string you are searching for:

var strings = [ "foo", "cool", "acl" ];
var needle = "c";

for (var i = 0; i < strings.length; ++i) {
    if (strings[i].substring(0, needle.length) === needle) {
        alert("found: " + strings[i]);
    }
}

score 1 · Answer 3 · answered Aug 28 '13 at 13:33

A simple way to do it is to check for words starting with 'c' and iterate of the array.

var ar = ['acl','cool','cat']
for(var i = 0 ; i<ar.length ; i++){
   console.log(ar[i].match(/^c/))
}
//Prints:
//null
//["c", index: 0, input: "cool"]
//["c", index: 0, input: "cat"]

Bart · Answer 4 · 2013-08-28T13:42:50.503

You can use the filter method which is available since JavaScript 1.6. It will give you back an array with the filtered values. Very handy if you want to match multiple items.

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/filter

var a = ["foo","fool","cool","god","acl"];
var startsWith = 'c';

a.filter(function (value) {
    return value && value.length > 0 && value[0] == startsWith;
});

// yields: ["cool"]

score 0 · Answer 5 · answered Aug 28 '13 at 15:06

0

var a = ["foo","fool","cool","god","acl"];
var Character="f";
for(i=0;i<a.length;i++){
    if(a[i].indexOf(Character)!=-1){

        document.write(a[i]+"<br/>");
    }
 }

answered Aug 28 '13 at 15:06

Rejayi CS

1,034
1
10
22

How to search an array in Jquery like SQL LIKE value% statement

5 Answers5