Answers.Body: <p>You can use basic pattern valid in <code>LIKE</code> operator of sql where clause.</p>
  
  <p>For Eg - Using <code>%tech%</code> would result in all three rows.</p>
  
  <p>Similarly you can use <code>[</code>, <code>]</code>, and <code>_</code> symbols. </p>
  
  <p>To find more about search strings - see <a href="https://dev.mysql.com/doc/refman/5.7/en/pattern-matching.html" rel="nofollow noreferrer">Pattern Matching in MySQL</a>  (AFAIK you can use only <code>LIKE</code> patterns here not <code>REGEXP</code>).</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-06-23T20:35:10.797Z
Answers.Text: did you mean B%tech% in order not to get eg MATech as a result?
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-06-25T06:22:50.740Z
Answers.Text: yes, that would work, `B%tech%` will list any value starting with `B followed by some chars and then tech <some chars>` which will exclude MATech from the result
Answers.UserDisplayName: jitendra - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-06-23T05:08:51.653Z
Answers.LastActivityDate: 2017-06-23T06:34:45.633Z
Answers.LastEditDate: 2017-06-23T06:34:45.633Z
Answers.UserDisplayName: jitendra - fuzion
Body: <p>I have a custom field for storing educational data. A person's degree is stored as either Btech or B.Tech or B.Tech.  so what should I give in search option so that I can get all 3 in my result in a single search? </p>
  
Tags: <custom-fields><search><search-results><custom-search><search-builder>
Title: searching custom field
ThreadText: # searching custom field
  
  (Asked by: username_0 on 2017-06-23)
  
  I have a custom field for storing educational data. A person's degree is stored as either Btech or B.Tech or B.Tech. so what should I give in search option so that I can get all 3 in my result in a single search?
  
  **Tags:** custom-fields, search, search-results, custom-search, search-builder
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-06-23. Score: 1
  
  You can use basic pattern valid in `LIKE` operator of sql where clause.
  
  For Eg - Using `%tech%` would result in all three rows.
  
  Similarly you can use `[`, `]`, and `_` symbols.
  
  To find more about search strings - see [Pattern Matching in MySQL](https://dev.mysql.com/doc/refman/5.7/en/pattern-matching.html) (AFAIK you can use only `LIKE` patterns here not `REGEXP`).
  
  > **Comments:**
  > **username_2**: did you mean B%tech% in order not to get eg MATech as a result?  
  > **username_1**: yes, that would work, `B%tech%` will list any value starting with `B followed by some chars and then tech <some chars>` which will exclude MATech from the result  
  
  ---
  
  