I have a case here where some unique number is assigned to all users created while signup (in others ). Now I need to search users based on that unique number.
I am facing two challenges here:
1. Search by some other column of the table
2. Other cat is stored in the some other table having that userid.
How can I modify the code.
a. data (column) from mdl_user_info_data holds the unique value - contains userid
b. mdl_user - basic data