Sql delete where in select

DELETE FROM tableA
WHERE ROWID IN 
  ( SELECT q.ROWID
    FROM tableA q
      INNER JOIN tableB u on (u.qlabel = q.entityrole AND u.fieldnum = q.fieldnum) 
    WHERE (LENGTH(q.memotext) NOT IN (8,9,10) OR q.memotext NOT LIKE '%/%/%')
      AND (u.FldFormat = 'Date'));

Source: stackoverflow.com

Similar codes

1 vote148 views2 answers
Mysql select tables with name like
SQL
0 vote139 views1 answer
Oracle for loop on list
SQL
0 vote147 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote153 views1 answer
Drop procedure sql
SQL
0 vote145 views1 answer
How to add session data into mysql database from button
SQL
18 votes134 views3 answers
Mysql query add column with default string value
SQL
1 vote144 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
2 votes149 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
4 votes156 views1 answer
Group by mysql and concatenate string
SQL
1 vote145 views1 answer
How to install mysql 8.0 windows service
SQL