on 01-14-2015 9:19 PM
What is the wild card for IS? * or % or something else?
If you are using patterns or regular expressions then the period is the wildcard for any character and * means 0 or more occurances. The expression (.*[0-9].*) would search for a number anywhere in the string. There are also some other operators which are good to know such as + 1 or more rather than 0 or more. The back of the IS manual has a full section on regular expressions and pattern matching.
I typically try to avoid the LIKE operator in expressions (rules, filters, etc.) and use it only in creating views. If you are using LIKE then % is the wildcard as in SQL. Concatenation uses || rather than + though so don't get yourself in trouble by trying to use a command LIKE '%' + $field + '%';
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It is %.
example $parameter0 like '%test%';
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.