DELETE `ud`.*
FROM `userdata` AS `ud`
JOIN (
SELECT CONCAT('ufi', `uf`.`dbIncrement`) AS `dataId`
FROM `ufields`
WHERE `podvedId` = 'val'
AND `formId` = 'val'
AND `parentContainerId` = 'val'
AND (`descriptor_y` = 'val' OR `descriptor_y` = 'val')
) AS `uf` ON `uf`.`dataId` = `ud`.`dataId`fabs(round(dotNum)-dotNum) > eps
M | P1(M)
1 | 0.25
2 | 0.25
3 | 0.19
4 | 0.13
5 | 0.08
6 | 0.05mysql> create table `test` (`val` longtext);
Query OK, 0 rows affected (0.45 sec)
mysql> insert into `test` SET `val` = '000123';
Query OK, 1 row affected (0.02 sec)
mysql> select * from `test` where `val` = 123;
+--------+
| val |
+--------+
| 000123 |
+--------+
1 row in set (0.00 sec)