CODEWITHSUNDEEP
javascriptmysql
user967451
user967451

Reputation:

What is the JavaScript equivalent of MySQL's %LIKE% clause?

In MySQL I use the like clause:

LIKE %some keyword%

to perform searches on database records. What can I use to similarly do a search in a JavaScript? So if a user enters something like

ger

it will show 

german shepard

Can't use:

str.search('ger');

since it seems to only match whole words

Upvotes: 18

Views: 72896

Answers (8)

yusuf_sabri
yusuf_sabri

Reputation: 129

I assume you have data came from database let say it is like

let names = ['yusuf', 'sabri', 'bayrakdar'];

You should use includes within a filter:

let searchValue = 'usu'
let filteredNames = names.filter(name => name.includes(searchValue));

filteredNames is going to be ["yusuf"]

Upvotes: 1

maerics
maerics

Reputation: 156434

Assuming you've got a bunch of records as an array of strings you can use the JavaScript built-in Array.filter method:

var ss = ['german shepard', 'labrador', 'chihuahua'];
var matches = ss.filter(function(s) {
  return s.match(/ger/);
});
matches; //output => ['german shepard']

Or if your target JavaScript doesn't implement that method (e.g. it implements ECMAScript prior to 5th edition), then you can do a simple array search, e.g:

var searchArray = function(arr, regex) {
  var matches=[], i;
  for (i=0; i<arr.length; i++) {
    if (arr[i].match(regex)) matches.push(arr[i]);
  }
  return matches;
};
searchArray(ss, /h/); //output => ['german shepard', 'chihuahua']

Upvotes: 4

user10597291
user10597291

Reputation:

my code:

// file name 1 = "E_000096_01.jpg"
// file name 2 = "E_000096_02.jpg"
// file name 3 = "E_000096_03.jpg"
// file name 4 = "E_000095_01.jpg"
var code = "000096";
var files = fs.readdirSync(dir).filter(file => file.indexOf(code) >= 0 ? true : false)
// result
console.log(files)
//["E_000096_01.jpg","E_000096_02.jpg","E_000096_03.jpg"]

Upvotes: 0

Ryan
Ryan

Reputation: 96

Here is an easy way to do it in JQuery.

This uses a filtering of text data inside of a table via a data-filter on the table row, but it can easily be used for other purposes.

$('#search').on('keyup', function() {
    var val = $.trim(this.value);
    if (val) {
        $('tr[data-filter!=' + val + ']').hide();
        $('tr[data-filter^=' + val + ']').show();
    } else {
       $('tr[data-filter]').show();
    }
});

In this example it will hide all table rows where an exact match wasn't found, and then filter by the start of the string value. The trim() function is useful in case all that's there is empty spaces, then it will still display everything as if a search was never made. If you want it to display the searched input where it's anywhere on the string, use a * instead of a ^. Both special characters are case sensitive. Also be sure that the hide command displays first and that both are present, or it won't work properly.

See another example here that utilizes both the ^ and * characters: http://jsfiddle.net/heatwaveo8/2VKae/

Upvotes: 0

Billy Moon
Billy Moon

Reputation: 58531

search function does not only return whole words. Maybe you are getting confused by the fact it returns zero-based index, so...

// this returns 0 as positive match at position 0
"german shepherd".search('ger')

// this returns -1 as negative match
"german shepherd".search('gerx')

So you need to do comparison of result of search against -1 to see if it is a match or not - you can not just check for true/false.

So you could do...

if(str.search('ger') !== -1){
    // matches string
} else {
    // does not match string
}

// or another way
// add one to convert result to one-based index, and check truthiness
if(str.search('ger')+1){
    // there is a match
} else {
    // there is not a match
}

Upvotes: 4

Mohsen
Mohsen

Reputation: 65785

it's not exact same as %LIKE% but you can use indexOf().

var str = "Mohsen",
    st = "Moh";

if(str.indexOf(st) > -1) // true

Upvotes: 43

Erik
Erik

Reputation: 1694

I'm not sure if all browsers support all of these methods: http://www.javascriptkit.com/jsref/string.shtml

But it looks like there's a String.match() method that'll do what you want.

Upvotes: 0

NT3RP
NT3RP

Reputation: 15370

I'm not sure exactly in what context you are using the like operator (e.g. a form field), but you probably want to take advantage of javascript's regular expression object.

A simple example (in your case, for a LIKE query), might look like this:

var regex = /.*ger.*/
var matchesRegex = regex.test(yourString);
if (matchesRegex) {
    //do something
}

Alternatively, you can search for the incidence of your string using the indexOf operation:

var matches = yourString.indexOf("ger") >= 0 ? true : false;
if (matches) {
    //do something
}

Upvotes: 8

Related Questions