Answers.Body: <p>There is an option called 'Automatic Wildcard' under CiviCRM &gt;&gt; Administer &gt;&gt; Customise Data and screens &gt;&gt; Search Preferences. Turning that off may fix your problem? But this setting will apply across whole site</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-02-07T12:44:03.077Z
Answers.Text: Hi Pradeep - I never knew that option was there! It works for our usecase, so thanks for the tip!
Answers.UserDisplayName: ChumKui
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-02-07T15:16:34.577Z
Answers.Text: Can you mark this as answered(tick box), if the solution worked for you? so that it can help others in the community
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-02-08T09:42:01.170Z
Answers.Text: Sorry Pradeep, all ticked, I upvoted but clearly forgot to tick...
Answers.UserDisplayName: ChumKui
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-02-03T13:45:33.603Z
Answers.LastActivityDate: 2023-02-03T13:45:33.603Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I have been experimenting with SearchKit - it has proved really useful. Thanks to everyone contributing.</p>
  <p>One of my fields on the form is a search on the Display Name of an orgnisational contact:</p>
  <p><a href="https://i.sstatic.net/YUoQS.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/YUoQS.png" alt="enter image description here" /></a></p>
  <p>All other search fields work really well, but the school name search will take any instance of a string of chars and return records containing that string.  We deal with schools, so if I search on <em>Mary</em>, this will also return records with <em>Primary</em> or <em>Maryland</em>.  Users tend to know the school they are after, but church schools in particular have a lot of *St Mary'*s etc.  This is of course just one example.  Capitalisation is not an issue, but hundreds of records are!</p>
  <p>So, is there a 'whole word only' setting anywhere one can turn on and off?</p>
  
Tags: <searchkit>
Title: SearchKit - Can I change a text search to whole word?
ThreadText: # SearchKit - Can I change a text search to whole word?
  
  (Asked by: username_0 on 2023-02-03)
  
  I have been experimenting with SearchKit - it has proved really useful. Thanks to everyone contributing.
  
  One of my fields on the form is a search on the Display Name of an orgnisational contact:
  
  [![enter image description here](https://i.sstatic.net/YUoQS.png)](https://i.sstatic.net/YUoQS.png)
  
  All other search fields work really well, but the school name search will take any instance of a string of chars and return records containing that string. We deal with schools, so if I search on *Mary*, this will also return records with *Primary* or *Maryland*. Users tend to know the school they are after, but church schools in particular have a lot of \*St Mary'\*s etc. This is of course just one example. Capitalisation is not an issue, but hundreds of records are!
  
  So, is there a 'whole word only' setting anywhere one can turn on and off?
  
  **Tags:** searchkit
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2023-02-03. Score: 2 | Accepted answer
  
  There is an option called 'Automatic Wildcard' under CiviCRM >> Administer >> Customise Data and screens >> Search Preferences. Turning that off may fix your problem? But this setting will apply across whole site
  
  > **Comments:**
  > **username_0**: Hi Pradeep - I never knew that option was there! It works for our usecase, so thanks for the tip!  
  > **username_1**: Can you mark this as answered(tick box), if the solution worked for you? so that it can help others in the community  
  > **username_0**: Sorry Pradeep, all ticked, I upvoted but clearly forgot to tick...  
  
  ---
  
  