Random search...

Germaris

Greetings!

How should I proceed to perform a random search in all the tables (or a given one) of a MySQL DB?
The variable sent may be a string or a number.

It's the kind of search we find on the first page of many websites...

Many thanks in advance for any tip !!!

kkobashi

Since you are using MySql, which is a relational database, you need to learn SQL (Structure Query Language). Get a MySql book and read it. There are plenty out there.

Germaris

Pfff!
Hard to read such a book in 24 hours!
Are you serious?

if (yes) {
print "&msg=You better not to reply to my post.";
}
else {
print "&msg-Ha ha ha! Good joke!";
}

dagon

what's a "random search"?

Germaris

dagon wrote:
what's a "random search"?

Very simple...

Say I want to find the string "earth" in a search performed through all the fields of three different tables: table1, table2 and table3.
Same search for the number "012345"...

dagon

and how is that random?

kkobashi

Germaris wrote:
Pfff!
Hard to read such a book in 24 hours!
Are you serious?
if (yes) {
print "&msg=You better not to reply to my post.";
}
else {
print "&msg-Ha ha ha! Good joke!";
}

It's clear you know very little about databases and SQL. Like I said, go read a book and educate yourself instead of being spoon fed the answer.