Possible Duplicate:
Emulating SQL LIKE in JavaScript
Is there an operator in JavaScript which is similar to the like operator in SQL? Explanations and examples are appreciated.
- 1stackoverflow.com/questions/1314045/…karim79– karim792009-08-22 05:55:08 +00:00Commented Aug 22, 2009 at 5:55
Add a comment |
6 Answers
You can use regular expressions in Javascript to do pattern matching of strings.
For example:
var s = "hello world!"; if (s.match(/hello.*/)) { // do something } The match() test is much like WHERE s LIKE 'hello%' in SQL.
2 Comments
kangax
It's better to use
test here (which should, by the way, be faster), since actual match result is not needed.
Phil Tune
Most definitely, use
/regex/.test(s) here, unless you want to do something with the matches - stackoverflow.com/a/10940138/1128978No.
You want to use: .indexOf("foo") and then check the index. If it's >= 0, it contains that string.
Use the string objects Match method:
// Match a string that ends with abc, similar to LIKE '%abc' if (theString.match(/^.*abc$/)) { /*Match found */ } // Match a string that starts with abc, similar to LIKE 'abc%' if (theString.match(/^abc.*$/)) { /*Match found */ } 
1 Comment
Faizan
how to match a string based on substring, for e.g if str="john edward" then how can I use the function to return true in both cases, like if str contains john => true , if str contains edward => should return true too.
You can check the String.match() or the String.indexOf() methods.
Comments
No there isn't, but you can check out indexOf as a starting point to developing your own, and/or look into regular expressions. It would be a good idea to familiarise yourself with the JavaScript string functions.
EDIT: This has been answered before:
Comments
No, there isn't any.
The list of comparison operators are listed here.
For your requirement the best option would be regular expressions.
1 Comment
Sandro Wiggers
Please provide some quality code with examples, rather than short yes or no answers, avoiding links that can be offline in the future.