Shawazi,
If it's worth it for your site, you may want to just create a column in your table where you can set a flag such as:
VL = anything above large amount
L = large amount of characters
M = medium amount of characters
S = small amount
XS = anything less than small.
Of course, it's at your discretion how many characters in an article constitues each flag. Once the flags are set in a column (for example) called "length", the query could be as follows:
SELECT *
FROM movies
WHERE movies.length = 'M'
OR movies.legnth = 'S'
OR movies.length = 'XS';
I imagine if you follow my suggestion, you'll have to 1.) use the ALTER TABLE command if you wish to append this column to an existing table and 2.) use PHP to get a count of the number of characters in a news article as in order to identify it the flag for it's "length". Might take some work, that's why I prefaced this post with "if it's worth it for your site". Else, the 2 query solution might be less problematic. Just trying to give you options, that's all.
