SELECT * FROM customer WHERE `expiration` != '0000-00-00' AND `expiration` > CURDATE();
This query will search for all accounts that are not inactive in customer table. It's a simple sample of using basic MySQL functions to perform a useful query.
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.