var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: REGEXP - querying a range of mid-values
I need a kind of a specific query, that would select a range of records.
Having a MySql table containing records with this pattern:
+ other sequences of this kind, for e.g.:
I'd like to select just the records inside the mid-value range, in other words...
...If user wants to select records with BRF as a prefix and TLE as a suffix, having mid-value range from 100-200,
SELECT result would be:
(although there are values beyond BRF-200-TLE)
Been experimenting with REGEXP:
SELECT from my_table
WHERE UserID REGEXP "^BRF-[100-200]"
...but it's beyond my SQL knowledge to figure out the complete formula
Seeing you guys in action around here, I'm confident you'll have something to suggest on this subject
Thnx in forward !