Page 1 of 1

Partial Record Display

Posted: Fri Jan 30, 2009 3:33 am
by Yanayaya
I am working on a small search engine that searches my mysql database.
It displays the details in rows. However it is showing the FULL job descriptions. To make my page more user friendley I would like to display on a few lines of the job description. Then the user could click on that particular result and view more details. So what I want to know is how can I show only a partial part of a mysql field??

Re: Partial Record Display

Posted: Fri Jan 30, 2009 6:18 am
by mavieng
SELECT LEFT(JobDescription, 100) FROM TABLENAME
// IT WILL PICK FIRST 100 CHARACTERS OF JOB DESCRIPTION FIELD


OR

SELECT LEFT(JobDescription, LENGTH(JobDescription)/2) FROM TABLENAME
// IT WILL PICK FIRST HALF CHARACTERS OF JOB DESCRIPTION FIELD

Re: Partial Record Display

Posted: Fri Jan 30, 2009 7:28 am
by Yanayaya
mavieng wrote:SELECT LEFT(JobDescription, 100) FROM TABLENAME
// IT WILL PICK FIRST 100 CHARACTERS OF JOB DESCRIPTION FIELD


OR

SELECT LEFT(JobDescription, LENGTH(JobDescription)/2) FROM TABLENAME
// IT WILL PICK FIRST HALF CHARACTERS OF JOB DESCRIPTION FIELD

Top stuff, thank you for that :)