473,321 Members | 1,669 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

How to cut long text in MySQL?

2
I have a long text store in MySQL about 10 lines for detail page. But in my home page i want to show Short text only 2 lines by using PHP query and let them click for detail. How can i cut this long text and show it?

Thanks in advance.
Jul 21 '07 #1
1 2929
kovik
1,044 Expert 1GB
Take a look into substr().
Jul 21 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Marek Lewczuk | last post by:
As far I remember full-text doesn't work with utf-8. Anybody knows the estimated time when it will be supported ?? I next few months 4.1 version will be ready to use (I hope so...) and I wish to...
0
by: Michael Widenius | last post by:
Hi! >>>>> "Bennett" == Bennett Haselton <bennett@peacefire.org> writes: Bennett> Is there any way to do a long update/delete on a table such that you can Bennett> view the progress as the...
1
by: Donna Wyer | last post by:
I passed my MySQL Core Certification Exam over three weeks ago; I passed the MySQL Professional Exam over a week ago. I still await my certificates from MySQL. I haven't even received my Core...
0
by: jnam | last post by:
I am having a problem putting a certain length of text from a textarea form element into a mySQL field. The field is set to LONGTEXT but I get an error. Whne I shorten the text it writes to the DB...
0
by: e r m | last post by:
I'm having the exact same problem as reported in Bug ID #'s 33476, 36305, 36020, and 34516. PHP 5.1.1 and 5.1.2 won't link against libmysqlclient.a. Environment details: Sun V440 Solaris 9...
2
by: maheshsugan | last post by:
Hello i am Mahesh, As i am using MYSQL as back end i created a table with LONGTEXT Feild, actually the size of LONG text is 4 GB , But it is not holding that much data, Can some one...
2
by: sadf | last post by:
I need to use MySql to store really large amounts of data . but when i try to store ,text file in long text field with LOAD_FILE command, the error i got was like : "Data too long for...
1
by: runsun | last post by:
I am new in PHP/Mysql. I want to input sth from website to mysql, then output the formatted data to .txt, and finally use Excel to open the .txt file. I believe there are better and simpler ways than...
0
by: M.E.R.C | last post by:
Hey Folks, Please forgive the complete ignorance, but I have a question regarding text datatypes and table creation. Further, I am coming from a Linux (Postgres/MySQL) and Microsoft (SQL...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.