How do you get a portion of a string?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How do you get a portion of a string?

SELECT SUBSTR(title, 1, 10) from techinterviews_questions;

(Continued on next question...)

Other Job Interview Questions

• Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
• What are HEAP tables in MySQL?
• What’s the difference between CHAR_LENGTH and LENGTH?
• Installing a MySQL Binary Distribution
• How do you change a password for an existing user via mysqladmin?
• How MySQL uses DNS
• MySQL - What issues should I be aware of when setting up two-way replication?
• MySQL - What should I do to prepare my client code to use performance-enhancing replication?
• MySQL - Setting Up Passwords
• How do I find out all databases starting with ‘tech’ to which I have access to?
• More...