How to setup analyzer to search number and string-number as string type ? like where like in SQL

Topic point: I want to know how to set up analyzer to search number and number+text like where %like% in SQL by data type of field is string

Hi, Im beginner atlas search and confuse about analyzer configuration

My problem is I created test collection and try to build countString Atlas search index ( countString filed is string data type but contain only number and number + ‘A’ value depend on is even or odd)

so I created simple analyzer but not quit good

{
  "mappings": {
    "dynamic": false,
    "fields": {
      "countString": {
        "analyzer": "lucene.simple",
        "multi": {
          "MultiAnalyzer": {
            "type": "string"
          }
        },
        "searchAnalyzer": "lucene.simple",
        "type": "string"
      }
    }
  }
}

and at the search tester with only number it should showing like 12, 121, 122, 123, 124 with 12 in that result but it’s nothing out

when I search with 12A it should get countString: '12A' but it’s incorrct

so Im here to asking for the community help

Topic point: I want to know how to set up analyzer to search number and number+text like where %like% in SQL by data type of field is string

Thanks for your answers and sorry for my bad english :smiling_face_with_tear: