php - 附加 where 子句

Question

我有以下代码来返回我想要的字符串

$sql = "
    SELECT `description` 
    FROM `auctions` 
    WHERE `description` REGEXP '[0-9]{10}'
";

但是我需要运行类似这样的更新查询

UPDATE `url` 
FROM `auctions_media`
WHERE `url` = "$sql" AND `auction_id` = SomeNumber

如何匹配表格，以便 auctions 表的 auction_id 与 auctions_media 表中的 auction_id 相匹配??

我希望代码遍历所有行，从描述中返回字符串，然后将其用于更新查询

Answer 1

也不完全确定你在追求什么，但也许是这样的:

UPDATE auctions_media JOIN auctions USING (auction_id)
SET    auctions_media.url = auctions.description
WHERE  auctions.description REGEXP '[0-9]{10}'

或者这个:

UPDATE auctions
  JOIN auctions_media
    ON auctions_media.auction_id = auctions.auction_id
   AND auctions_media.url        = auctions.description
SET    ...
WHERE  auctions.description REGEXP '[0-9]{10}'