KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have MySQL database that has a table with book data in it. One of the columns in the table is called "title". Some of the titles begin the word "the" and some do not. Example: "The Book Title One" "Book Title Two" "Book Title Three" I need to pull these out of the database in alphabetical order, but I need to ignore the "the" in the beginning of the titles that start with it. Does SQL (specifically MySQL) provide a way to do this in the query?
Tags (comma-separated)
Save Edits
Cancel