GUID to Names?

I am trying to get the names of the user , by extracting it by manual SQL queries on PHPmyadmin. But I get it in terms of guid's , And i want it in terms of names of people , ANY IDEA how to convert this guids to names in MYSQL queries? 

  • there is a table "users_entity" which holds the basic information of a user (name, username, email).

    My question would be why are you using PHPMyAdmin to get this information? There are tools on the community like Profile Manager which allow you to export information about the users.

  • I want to make a graph in GEPHI so that has to be generated in the CSV format , which only PHPmyADMIN can do , do you know any plugin that can export information in terms of CSV or GEFX format ?


  • i dont know how soon you want it but i too have been trying to do this...let me see if i can get it done before end of next week...but follow @ jerome Bakker's advice; profile manager exports to csv

Beginning Developers

Beginning Developers

This space is for newcomers, who wish to build a new plugin or to customize an existing one to their liking