php–MySQL：从总值中只显示200个字符

概述我有一个MySQL表,其中包含一个名为description的字段,其中包含如下记录： Former cop Brian O'Conner partners with ex-con Dom Toretto on the opposite side of the law.Since Brian and Mia Toretto broke Dom out o

我有一个MySQL表,其中包含一个名为description的字段,其中包含如下记录：

Former cop Brian O’Conner partners with ex-con Dom Toretto on the opposite sIDe of the law.Since Brian and Mia Toretto broke Dom out of custody,they’ve blown across many borders to elude authoritIEs. Now backed into a corner in Rio de Janeiro,they must pull one last job in order to gain their freedom. As they assemble their elite team of top racers,the unlikely allIEs kNow their only shot of getting out for good means confronting the corrupt businessman who wants them dead. But he’s not the only one on their tail. Hard-nosed federal agent Luke Hobbs never misses his target. When he is assigned to track down Dom and Brian,he and his strike team launch an all-out assault to capture them. But as his men tear through Brazil,Hobbs learns he can’t separate the good guys from the bad.

如何显示前200个字符？像这样：

Former cop Brian O’Conner partners with ex-con Dom Toretto on the opposite sIDe of the law.Since Brian and Mia Toretto broke Dom out of custody,they’ve blown across many borders to elude authoritIEs.

最佳答案

SELECT left(description,200)FROM yourtable

相关文档here. 总结

以上是内存溢出为你收集整理的php – MySQL：从总值中只显示200个字符全部内容，希望文章能够帮你解决php – MySQL：从总值中只显示200个字符所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。