🤑 Join the Treehouse affiliate program and earn 25% recurring commission!

New No-Code Track! 🚀 New videos dropping every week—start learning today!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

  • Treehouse Logo
  • Plans
    Chevron
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
  • Library
    Chevron
    • All Courses
    • Tracks
    • College Credit
  • Techdegree
    Chevron
    • Overview
    • Front End Development
    • Full Stack JavaScript
    • Data Analysis
    • UX Design
    • Python
  • Community
    Chevron
    • Community Projects
    • Live Sessions
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
  • Resources
    Chevron
    • Career Toolbox
    • CodeForward
    • Free Treehouse Near Me
    • Jobs
    • Blog
    • Support
    • About
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks College Credit
  • Overview Front End Web Development Full Stack JavaScript Python Development Data Analysis UX Design
  • Community Projects Live Sessions Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Career Toolbox CodeForward Free Treehouse Near Me Jobs Blog Support About
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • Android
      • • APIs
      • • Coding for Kids
      • • College Credit
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Game Development
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • No-Code
      • • PHP
      • • Professional Growth
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
      • • Swift
  • Jeff Styles
    Jeff Styles
    2,784 Points

    Using LENGTH function as a condition without issuing an alias or displaying its value in output...

    Posted February 2, 2017 7:22pm by Jeff Styles
    Jeff Styles
    2,784 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    0 Answers

  • Sebas Pinto
    Sebas Pinto
    462 Points

    What benefit has manipulate Strings directly in the query and not in the Programming Language that i'm using for my app?

    Posted September 8, 2016 12:09am by Sebas Pinto
    Sebas Pinto
    462 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    1 Answer

  • Ricardo Vargas
    Ricardo Vargas
    3,583 Points

    Using functions better practices question

    Posted August 8, 2015 7:58pm by Ricardo Vargas
    Ricardo Vargas
    3,583 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    1 Answer

  • John Magee
    PLUS
    John Magee
    Courses Plus Student 9,058 Points

    Improper MySQL Syntax used in this Video - String Functions - Database

    Posted March 12, 2015 10:28pm by John Magee
    John Magee
    Courses Plus Student 9,058 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    0 Answers

  • Viktoria S
    Viktoria S
    6,773 Points

    How does sql know what is username? did we specified it earlier what is username consist of?

    Posted March 7, 2015 4:46pm by Viktoria S
    Viktoria S
    6,773 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    1 Answer

  • Sebastian Velandia
    Sebastian Velandia
    24,676 Points

    How to select star (*) but add a string function to one of the columns?

    Posted November 25, 2014 5:16pm by Sebastian Velandia
    Sebastian Velandia
    24,676 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    1 Answer

  • Joe Hilton
    PLUS
    Joe Hilton
    Courses Plus Student 4,893 Points

    Slightly confused with the SUBSTRING clause in my MySQL command.

    Posted July 31, 2014 5:39pm by Joe Hilton
    Joe Hilton
    Courses Plus Student 4,893 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    2 Answers

  • Joe Hilton
    PLUS
    Joe Hilton
    Courses Plus Student 4,893 Points

    Can anyone point me in the right direction as to what's wrong with my MySQL code please

    Posted July 31, 2014 4:32pm by Joe Hilton
    Joe Hilton
    Courses Plus Student 4,893 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    4 Answers

  • Bruno Calheira
    Bruno Calheira
    12,625 Points

    When should I use HAVING in SQL Statements?

    Posted July 2, 2014 8:06pm by Bruno Calheira
    Bruno Calheira
    12,625 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    2 Answers

  • Coders Unlimited
    Coders Unlimited
    10,112 Points

    Select the first letter of the "first_name", add a period after it, followed by a space and add the "last_name". Also, convert "last_name" to upper case. Call it "name". Example: "A. CHALKLEY".

    Posted February 27, 2014 6:42am by Coders Unlimited
    Coders Unlimited
    10,112 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    3 Answers

  • Coders Unlimited
    Coders Unlimited
    10,112 Points

    String Function

    Posted February 27, 2014 6:37am by Coders Unlimited
    Coders Unlimited
    10,112 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    2 Answers

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.

    Treehouse

  • About
  • Blog
  • Careers
  • Community
  • Stories
  • Shop
  • Contact
  • Gift Card

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Affiliates
  • Perks
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2025 Treehouse Island, Inc.