Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- How to trim text in my query ?


matchipette - 3:00 pm on Nov 16, 2012 (gmt 0)


sorry guy I forget to thank you for pointing to me on the right direction :-(

In my case the follow code do the job:


SELECT SUBSTRING(`myfieldname`,1,200) FROM `mytable` WHERE `user_id` = '[user_id]'

all the best

cheers


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4511170.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com