I was talking with one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. He mentioned to me that several customers have been telling him that “MongoDB doesn’t scale!” MongoDB’s scalability was in question?
My response was, “Is that a joke?"
Course Of The Month
11 days, 15 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MySQL query with substring
Posted on 2014-01-07
What is wrong with this:
SELECT * FROM `citrans` WHERE substring(dtstamp,0,4) = '2012'.
See attached for structure of table citrans.
There are hundreds of records with year = 2012.
citrans-str.jpg
SELECT * FROM `citrans` WHERE substring(dtstamp,0,4) = '2012'.
See attached for structure of table citrans.
There are hundreds of records with year = 2012.
citrans-str.jpg
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Active today
Are you getting an error message? MySQL doesn't keep the DATETIME columns in text format but in an internal binary format. It converts them to text when it returns them.
I wouldn't do it that way. This is what I use.
I wouldn't do it that way. This is what I use.
SELECT * FROM `citrans` WHERE `dtstamp` >= '2012-01-01' AND `dtstamp` < '2013-01-01'
SUBSTRING is for text fields, better to use a date function:
SELECT * FROM citrans WHERE YEAR( dtstamp ) = '2012'
SELECT * FROM citrans WHERE YEAR( dtstamp ) = '2012'
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Foreword
In the years since this article was written, numerous hacking attacks have targeted password-protected web sites. The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided. Of cou…
Foreword
This is an old article. Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead. More information is available here: MySQLi / PDO (http://…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month11 days, 15 hours left to enroll
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.