samedi 25 avril 2015

How to compare length of data in mysql type text using php?


i have this table name = text_tab

 _________________________
|  id  |     message     |
|  1   |     aaa         |
|  2   |     bb          |
|  3   |     ffff        |
|  4   |     ooooooo     |
|  5   |     gg          |

I want to check row that data in column message have max char. And column message is type text.

in my answer will show id=4

I use order by message desc but not work, How can i do that ?


Aucun commentaire:

Enregistrer un commentaire