Sort data from the MYSQL field

0

In a field of the database in mysql some logs are saved that each user makes in the system, which keeps them like this:

  • - > keys < - - > fields < -
  • visits_id: 0
  • run (new): 11111111-1
  • start_date (new): 2017-11-21
  • new_date (new): 2017-11-21
  • uurr (new): 65
  • reason (new): 11
  • observations (new): SURPRISED BY TAKING PENCILS.

and the question is how I can order or format that data, so it looks like this:

  • Run: 11111111-1
  • start_date: 2017-11-21
  • deadline: 2017-11-21

Thanks

    
asked by Francisco 13.03.2018 в 13:07
source

0 answers