title: Weekday(date) compare with current date weekday
body: <pre><code>SELECT 
    * 
  FROM
    (`users`) 
    JOIN `artistprofiles` AS art 
      ON `art`.`user_id` = `users`.`id` 
  WHERE WEEKDAY(users.date_created) = 'WEEKDAY(WEEKDAY(NOW()))' 
    AND `users`.`status_enum` = 'aproved' 
    AND `users`.`status` = 1 
  ORDER BY `users`.`email_process` DESC 
  </code></pre>
  
  <p>what is the problem with this query . it gives me wrong result</p>