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

Question

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

User · Answer

SELECT SUBSTRING subject  1  10  FROM tbl

User · Answer

Have a look at either Left or Substring if you need to chop it up even more   Google and the MySQL docs are a good place to start - you ll usually not get such a warm response if you ve not even tried to help yourself before asking a question

User · Answer

Using the below line  SELECT LEFT subject   10  FROM tbl    MySQL Doc

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

Examples related to mysql

Examples related to sql

Examples related to select