MySQL Select Query - Get only first 10 characters of a value

mysql sql select
getvivekv picture getvivekv · Feb 19, 2013 · Viewed 244.3k times · Source

Ok, so here is the issue.

I have a table with some columns and 'subject' is one of the columns. I need to get the first 10 letters from the 'subject' field no matter the 'subject' field contains a string with 100 letters.

For example,

Table - tbl. Columns - id, subject, value.

SQL Query: 

SELECT subject FROM tbl WHERE id ='$id';

The result I am getting is, for example

Hello, this is my subject and how are you

I only require the first 10 characters

Hello, thi

I can understand that I can remove the rest of the characters using php substr() but that's not possible in my case. I need to get the excess characters removed by MySQL. How can this be done?

Answer

MuhammadHani picture MuhammadHani · Feb 19, 2013

Using the below line

SELECT LEFT(subject , 10) FROM tbl

MySQL Doc.

Related questions

SQL query return data from multiple tables

I would like to know the following: how to get data from multiple tables in my database? what types of methods are there to do this? what are joins and unions and how are they different from one another? When …

Read More
MySQL SELECT only not null values

Is it possible to do a select statement that takes only NOT NULL values? Right now I am using this: SELECT * FROM table And then I have to filter out the null values with a php loop. Is there a …

Read More
MySQL INNER JOIN select only one row from second table

I have a users table and a payments table, for each user, those of which have payments, may have multiple associated payments in the payments table. I would like to select all users who have payments, but only select their …

Read More