I have a very simple query that used to work and then recently stopped. It
goes something like:
SELECT name FROM Items WHERE category RLIKE '^\* new cat \*';
Now, I'm pretty familiar with how regex works, and I was pretty sure that
when I put a \ in front of the * it would interpret it as a * i
I was just browsing through the searchable online MySQL manual, trying to
find a list of the aggregate functions (as I don't trust the list in the
O'Reilly book, considering the number of typos and missing information in
other sections), and couldn't find anything.. Is there a list in the
manual?
> SELECT RTRIM(CONCAT(parents, ' ')) AS parents, name FROM Categories ORDER BY
> parents, name;
>
> Note:
>
> SELECT RTRIM(parents) AS parents, name FROM Categories ORDER BY parents,
> name;
>
> works SOMETIMES, but not in every case.
Ammending this, as I did a little more testing.. U
My ISP recently updated one of their servers to 3.23.38, and all of a sudden
a BUNCH of my code stopped working. I use a number of insert queries (new
items, new search caches, etc), where I insert a blank record, and then take
notes of its id (usually "int unsigned auto_increment primary key"),
> Woops sorry about that last message.
> Try using the following:
> my $id = $sth->{insertid};
> That is what I had to change it to, to get it working.. despite what the
> documentation says.
Actually, I can't use that. The script dies, it's not like it just warns me
that it doesn't work, but it
> Two things you might want to try... first download and install the newest
> Msql-Mysql DBD drivers.. check what the documentation says in there.. and
> second, keep changing what variable you are trying to access and maybe you
> will find one works that isnt documented.
My problem with this is
