[Miguel]

You can use sscanf aswell:

pawn Код:

new
  line[1], // this depends on how much data are you storing there
  query[70]; 

format(string, sizeof(string), "SELECT * FROM `tablename` WHERE `columnname` = '%s'", VARIABLE);
mysql_query(query);
mysql_store_result();
mysql_fetch_row_format(line, "|");
sscanf(line, "p|dsf", variable1, variable2, variable3); // This is gonna place all the data delimited by a | into those variables, note there are just 3.
mysql_free_result();