I have a meta field "my_meta_field" which may contain the following for these sample users:
99999 559225 12519
5020492 99999 125191
Newlines are \r\n or \n. This is on Mac for dev and Unix for server side so it is probably \n.
If the target number is 99999 then I should get a match for User A and B. Need to be careful not to match situations like User C where a number has the target inside "1199999"
Matching start of line, or \n, or \r\n at the beginning should take care of this.
$user = get_users( array( 'meta_query' => array( array( 'key' => 'my_meta_field', 'value' => '(^|\\n|\\r\\n)99999', 'compare' => 'REGEXP', ), ), ) );
Unfortunately this only matches User A correctly. It doesn't match User B. This regular expression works perfectly in tools such as https://regex101.com/.
I've tried different formats such as:
Thank you in advance if anyone knows what's wrong here.