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
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 with no issues
