It's been a few years since I did any regex queries, but I swear I used
to be able to do something like:
SELECT fieldname FROM tablename WHERE field RLIKE '(^|\|)2(\||$)';
And that would find '2', with an optional '|' at the beginning, or at
the beginning of the line, and an optional '|' or en
Does anyone have a clever way that I can sort on two fields? Let me
explain...I need the sort to be by the "uid" field (see below), but also
have the "parent" field taken into consideration:
Here's a sample of what I get now:
+---+---++
| uid | duplicate | parent |
+---+
> Hi Joseph,
>
> Joseph Koenig wrote:
>> Hi,
>>
>> I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I moved the
>> data directory of MySQL. I updated everything that SELinux complained about,
>> etc., and have a functional install of MySQL. It's actually been up and
>> running wit
