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??
Partial Record Display
Moderator: General Moderators
Re: Partial Record Display
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
// 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
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