Correct MySQL Syntax for WEEK

by 

SELECT (CASE WHEN WEEKDAY(NOW()) > 3 THEN 
    WEEK(NOW(),1) 
ELSE 
    WEEK(NOW()) END) 
AS result;

More Related Contents:

  1. Complex Count in MySQL
  2. Using column alias in WHERE clause of MySQL query produces an error
  3. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  4. Cannot delete or update a parent row: a foreign key constraint fails
  5. Using union and order by clause in mysql
  6. Using an Alias in SQL Calculations
  7. How do I select an entire row which has the largest ID in the table?
  8. MySQL/MariaDB – order by inside subquery
  9. Can MySQL replace multiple characters?
  10. OUTPUT Clause in MySQL
  11. Search all columns of a table using a single where condition with single keyword in mysql
  12. Using ORDER BY and GROUP BY together
  13. Sorting by date & time in descending order?
  14. Case statement in MySQL
  15. MySQL Pivot Table Column Data as Rows
  16. updating columns with a sequence number mysql
  17. MySQL, Concatenate two columns
  18. Select a column with a keyword name
  19. MySQL: Inner join vs Where [duplicate]
  20. ERROR 1148: The used command is not allowed with this MySQL version
  21. Selecting from two tables with inner join and limit [duplicate]
  22. Use Composite Primary Key as Foreign Key
  23. How to select data where a field has a min value in MySQL?
  24. How to SELECT by MAX(date)?
  25. get a recursive parent list
  26. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  27. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  28. MySQL update statement to store ranking positions
  29. How to convert a varchar column type to date type without losing the dates
  30. MySQL Multiple Joins in one query?

Leave a Comment