Barand
-
Posts
24,344 -
Joined
-
Last visited
-
Days Won
795
Community Answers
-
Barand's post in how to delete from a table was marked as the answer
This could work
$str = 'HG||Fxg|||ergx||xx'; // replace "|||" with "','" so you have separate records split by quote-comma-quote $str = str_replace("|||", "','", $str); $sql = "DELETE FROM _projecttbl WHERE P_id = 1 AND CONCAT(Prt_id, '||', Oth_id) NOT IN ('$str')"; -
Barand's post in Complex query help was marked as the answer
try
SELECT COUNT( * ) AS total FROM `nem_pae_atividades` WHERE `idutilizador` =1355 AND `data` <= CURDATE( ) AND ( `realizado` IS NULL OR LENGTH( `realizado` )=0 )