Querying record with includes operator

Certified Lead Developer

Dear Team,

We have a column in DB say file_number which have text values example 1;12 , 12;32

We are trying to query records where file_number is "1" using includes operator. With includes in query it is getting all the records which have 1 (1,12,13). We want the search to match exact to 1 only .

Any suggestion ? One suggestion we have is to add a character when writing in DB like @1@;@12@ , and when searching pass @1@.

  Discussion posts and replies are publicly visible