check if thread exist

[zoro]

Hello

i got table that got threadid but some of the threads were deleted how can i check if the threadid from my table still exist in the thread table and if not to delete it ??

:surprised:

[Marco van Herwaarden]

You are looking for a simple SQL, that can do the job once?

[AN-net]

use the fetch_info function and then check to see if it returns a thread_id, if it doesnt run a delete query to delete that entry from your table.

[zoro]

MarcoH64 Yeah

[Marco van Herwaarden]

You could do something like:
[sql]DELETE FROM mytable
WHERE NOT EXISTS (select threadid FROM thread WHERE thread.threadid = mytable.threadid)[/sql]
The above will only work for MySQL 4.1 (or was it 4.0) and above.

PS This was not tested, so use on a test database first.

[zoro]

thank you very much