codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    DateTime format – search or delete – Wildcard

    30th May 2014

    MySql

    mysql codehaven category

    DateTime format can cause a problem when deleting or searching and only wanting to use the day in question not the time as well.

    Use this code to get round that problem…use the wildcard!

    1
    2
    3
     
    DELETE FROM reports WHERE mydate > "2014-05-30 *"
     

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN