Msg#: 4511170 posted 8:15 am on Oct 23, 2012 (gmt 0)
I need to make a query (mysql database) for get the content of a specific texarea field. For do that I use the follow query:
SELECT `mytextareacolumn` FROM `my_table` WHERE `user_id` = [user_id]
Using this query allow me to get the full content of the texarea for each of my users but my goal was to get only the first 200 character and not the full text. Somebody told me is possible to do something using the SQL functions such as SUBSTR but I don't know how to include this function in my query.