how to search all user meta data that have value like “vivek”

As you said data is stored inside meta_value as serialized format. You can match your string among the serialized string like data. 

$args = array(
'meta_query' => array(
    array(
        'key' => 'submitted',
        'value' => sprintf(':"%s";', 'vivek'),
        'compare' => 'LIKE'
    )
)
);

$query = new WP_User_Query( $args );

Hope this help!

Related Posts:

  1. User Relationship
  2. How to pass user meta_key and meta_value (values as array)
  3. last_name + first_name orderby with meta_query [solved]
  4. wordpress meta value compare between two date
  5. get_users with Serialized Custom Meta Value
  6. get_user can’t read variable
  7. Memory Leak in Processing Large JSON file
  8. Query for user roles and their skills
  9. wp_user_query with meta_value_num for leaderboard
  10. How to do a meta query using REST-API in WordPress 4.7+?
  11. Meta query terribly slow
  12. meta_query sorting by 2 keys
  13. How to handle optional end date in compare clause in meta_query
  14. Using meta_query on pre_get_posts to exclude a particular meta_key value
  15. How do you get posts by meta_query using the JSON API plugin?
  16. Best practice – Meta Query vs. post_clauses for “left join” ordering
  17. Combining Meta_Query key values for one array
  18. Different page parameters inside query
  19. meta_query key value from array
  20. LIKE %…% Meta Query
  21. Documentation for post meta
  22. Arrange Posts By Date In Order Of Closest To The Current Date
  23. Custom Upcoming Events List for Events Manager Plugin
  24. How to use meta_query to check if a meta field has something set?
  25. How to make a WP REST API query with meta_query in WP4.7?
  26. WP User Query fails when searching meta queries and search columns
  27. Use both meta query and tax query
  28. Query posts only if meta_value is not empty
  29. Query Multiple values for same key
  30. Meta query with a sub query group possible?
  31. WP_user_query throws a 404 error
  32. meta_query compare=’!=’ with multiple custom fields
  33. Query posts with numeric meta values within a given range
  34. meta_query not working on live site
  35. How do you get Posts by multiple meta_keys and meta_values with the Rest API V2?
  36. Meta_query on same meta key, with diffrenct values
  37. Query custom field with date
  38. Meta query with regular expression does not work
  39. Searching in title or meta, with a tax query too!
  40. strange issue with user_meta + json_encode/decode
  41. Pre Get Posts / Multiple Meta Keys / Orderby Single Key
  42. Help on multiple meta_query
  43. Meta query – How to display a null meta key
  44. pre_get_posts and set
  45. meta_query with multiple values optimization
  46. Get a single post ID based on an exact match of 1 or more meta values
  47. How to pull all the contributer users records and order by Designation (which is users meta data)?
  48. ACF: How to get users with a ACF flexible content subfield with a specific value AND layout?
  49. Extend meta query arguments
  50. get_posts( $args ) return empty data
  51. User Meta Value not echoing despite Var_Dump Showing correct string
  52. how to get post meta where value is an array of key value pairs
  53. Search users with custom meta data
  54. Find posts by related taxonomy field
  55. Can I use pre_get_posts to add up values from two different meta_keys?
  56. WP JSON API meta_query not working
  57. Sorting posts by ACF field
  58. Ordering custom posts by meta field date
  59. latitude/longitude meta_query
  60. How to: get_user_meta – BuddyPress [closed]
  61. meta_query displays all results and none, my query is wrong
  62. How to properly escape values in meta query
  63. Fetch custom post related to a User
  64. How to Ordering by user meta
  65. Use meta_query in args for relationship
  66. How do I echo all users’ display_name and their meta_value who have a certain meta_key?
  67. meta_query compare “=“ returns nothing when it seems it should
  68. Order resultset by configured value and then list all the rest
  69. Best Practice? – Saving multiple Values as Serialized Data / Saving each Value per Row / Dedicated Table
  70. How to get an archive page meta?
  71. user metadata in json format, update the data partly only
  72. Search for value(s) in meta field for a multi select
  73. How to save multiple values with same meta_key, each value linked to another tag id
  74. Querying terms with calculations based on term meta data, sql vs. get_terms
  75. How to do WP_User_Query for Nested Array value Inside Nested Array field
  76. How to select meta key in custom database query
  77. WordPress meta query not working
  78. Get meta_value from GDRating
  79. Unusual high query of user meta data
  80. meta_query orderby sort multiple keys
  81. Why does this incorrect pre_get_posts meta_query work for sort order?
  82. How to sort custom posts including null meta-values ​in admin columns with meta_query?
  83. Exclude Posts Using Meta Query and User Meta
  84. meta_query not filering but meta_key works fine
  85. get posts meta query returning the latest post if no meta key found
  86. Search using specific meta fields only (excluding post title and content)
  87. How to fetch WP_User_Query with multiple role arguments [duplicate]
  88. How to get meta value based on latest post id with group by term name
  89. Meta query not returning results even though the sql contains the information
  90. Display Users from two roles in one list
  91. WP_Query with UNIX timestamp in meta query
  92. Multiple Queries with meta_query
  93. Get foreach for meta_query value
  94. list or get meta_key where meta_value is ‘something’
  95. order by meta_key [duplicate]
  96. WordPress Meta Query very slow with NOT EXISTS comparison
  97. ACF meta_query field treated as “0” resulting in false negative search when testing ranges
  98. Is it possible to customize meta query in this way?
  99. Ordering WP_Query results by second meta_key
  100. How making a new search box in admin post table working on a specific column
error code: 523