Rsa97

SELECT * 
  FROM `table` 
  WHERE `date` BETWEEN '2016-05-01' AND LAST_DAY('2016-05-01')

SELECT `u2`.*
    FROM `users` AS `u1`
    JOIN `users` AS `u2` ON `u1`.`user_id` = :user_id AND `u2`.`ip` = `u1`.`ip`

$user = 170;
$query->bind_param('ssi', $message, $date, $user);

$query = $database->prepare("INSERT INTO messages(message,date,id_user) VALUES(?, ?, 170)");

CREATE DATABASE IF NOT EXISTS `_mo` DEFAULT CHARACTER SET latin1;

DELETE `ud`.*
  FROM `userdata` AS `ud`
  JOIN `ufields` AS `uf` 
    ON `ud`.`dataId` = CONCAT('ufi', `uf`.`dbIncrement`) 
    AND `uf`.`podvedId` = 'val' 
    AND `uf`.`formId` = 'val' 
    AND `uf`.`parentContainerId` = 'val' 
    AND (`uf`.`descriptor_y` = 'val' OR `uf`.`descriptor_y` = 'val')