mysql - 更新表列mysql

Question

我想更新某些列的值，所以我使用了这个简单的查询，但它不起作用，有人可以提出任何建议吗？

UPDATE 'tableA'
SET post_parent = (SELECT wp.ID FROM `tableA` wp 
                   WHERE wp.post_content='' AND wp.post_name='ba' AND wp.post_type='pa')    
WHERE ID IN (SELECT ID FROM `tableA` WHERE post_name like '%ba-%' AND post_type='pa') 

Answer 1

UPDATE tableA
SET post_parent = (SELECT wp.ID 
                   FROM tableA wp 
                   WHERE wp.post_content='' 
                   AND wp.post_name='ba' 
                   AND wp.post_type='pa')
WHERE ID IN ( SELECT ID 
              FROM tableA 
              WHERE post_name 
              like '%ba-%' 
              AND post_type='pa')