Search options about tablefield

[oriadam]

From [email protected] on March 12, 2013 06:08:25
// search structre: s1,s2,s3 and up to s12
// fname.searchquery.method.or
// fname = field in which to search
// search query = what to search. dots needs to be replaced by %2E before encoding (double encoded)
// or = Optional. How to chain to next line? 'or' means OR, AND in any other case.
// method: for negative search add '-' before the method name
// in = Has: (LIKE '%Q%')
// -in = Doesn't have: NOT (LIKE '%Q%')
// a = Starts with: (LIKE 'Q%')
// -a = Doesn't start with: NOT (LIKE 'Q%')
// z = Ends with: (LIKE '%Q')
// eq = Exact match case sensitive: (f='Q')
// ci = Exact match Case Insensitive: (f LIKE 'Q')
// rx = Regular expression query: (f RLIKE Q)
// b = boolean. Works only with numeric (=non zero) and boolean fields: (f)
// n = Null values: (f IS NULL)
// e = Empty values: (f='')
// gt = Greater Than. Note search-query is little than field: (f<Q)
// gte = Greater Then or Equal to: (f<=Q)
// lt = Little Than: (f>Q)
// lte = Little Then or Equal to: (f>=Q)