Hello AgustÃn,
Monday, April 22, 2002, 11:50:44 PM, you wrote:
AF I have a question on a project i am currently on. I am adapting Phorum
AF (www.phorum.org) to my own portal and have a doubt about MySQL. Phorum
AF creates a table for each discussion forum. However, in the portal i work
AF for,
Hello olinux,
If I were in your shoes, I would put not only paths to images into a separate
table, but also a field called content and probably title, summary,
author and linked all this stuff together via ID-like fields which are
primary keys in those new tables. Then articles table can be
Hello Mikael,
Just add LIMIT 10 (which is equivalent to LIMIT 0,10) to show the
first 10 records,
and
LIMIT 10,10 to show 10 records starting from 10.
This issue is covered in online docs.
Regards,
Tom
Friday, April 19, 2002, 9:18:53 AM, you wrote:
MH This brings up another question to
Hello Paul,
But RLIKE won't use indexes (even if they exist), so why RLIKE '^A' is
better than LIKE 'A%', if LIKE which starts at the beginning of the
string **will** use indexes?
Regards,
Tom
PD Regular expression patterns (unlike SQL patterns) don't need to match the
PD entire string, so
Hello developers,
When you write another MySQL-based search engine, you
obviosly test it issuing queries against big amounts of data which contains more
or less sane text. Tell me, where (or how) you usually get the text
when you need, say, 10GB of it and, I repeat, it should be a REAL
Hello aToM,
It works if you double escape character, i.e.
select Artist, Track from tracks where Track regexp 'Rumour \\(';
in your case (just tested myself). Looks pretty weird, but seems to
work.
Tom
Sunday, March 10, 2002, 10:48:07 AM, you wrote:
a I have a db with some data that
Hello Paul,
Thank you for a quick reply.
It doesn't look same way :(. Normally I've read data from a file on a client's
machine
using Perl's read function like this
while(read($file, $data, 1024))
{
print TO $data;
}
to write it from $file on client's computer to a file associated with