Hi,
I have a database with a table with 10000 links but i want to grab out 200 links with a minimum description lenght is this possible via mysql?
Cheers
Kris
Getting data with minimum lenght
Moderator: General Moderators
Code: Select all
SELECT `column1` FROM `table` WHERE CHAR_LENGTH(`column2`) > 20With MySQL it's possible as following:
Code: Select all
SELECT whatever
FROM table
ORDER BY CHAR_LENGTH('description') ASC
LIMIT 0, 200