MySQL将随机行从一个表移动到另一个表

Question

Is it possible to move a random row(with one column) to another table in that way so no one get this data even if will request it simultaneously?

For example: If you open my page, you get a data from MySQL that no one will get even if open this page simultaneously with you.

Now I do it this way:

mysql_query("INSERT INTO `ShowRow` SELECT * FROM `AllRows` WHERE 1 LIMIT 1");
mysql_query("DELETE FROM `AllRows` LIMIT 1");

Is it possible to do some another better way? Or how to SELECTsome specific row if there is only one column?

Answer 1

Thank you to all, but I have come up to do it this way:

$accCount = mysqli_query($connect, "SELECT * FROM AllRows");
$accCount = mysqli_num_rows($accCount);
$RandAcc = rand(0, $accCount);
$result = mysqli_query($connect, "SELECT * FROM `AllRows`");
$ReplaceRandAcc = mysqli_result($result, $RandAcc);

mysqli_query($connect, "INSERT INTO `ShowRow` SELECT * FROM `AllRows` WHERE login='".$ReplaceRandAcc."'");
mysqli_query($connect, "DELETE FROM `AllRows` WHERE login='".$ReplaceRandAcc."'");

function mysqli_result($res, $row, $field=0) {
    $res->data_seek($row);
    $datarow = $res->fetch_array();
    return $datarow[$field];
}