Evn f ur prfsnal u nd 2 shw efrt. <--- This is hard to read
Even if you're a professional you need to show effort before we help you.

I'm gonna go head and say no. (http://www.daniweb.com/forums/announcement8-2.html)

Might want to take a look in your textbook or around the MySQL documentation before you start asking homework questions without showing work.

Wow, I can't believe I suggested that. That is insanely slow and stupid, sorry. Just do
$search = str_replace(' ', '%', $search);

That's called the ternary operator.


$somevar = (condition) ? (true case) : (false case);
// so
$test = true;
$somevar = $test ? "Hello" : "Goodbye";

// is the same as
$test = true;

$search = join('%', explode(' ', $search));
/*
For Example:
search = 'John Smith';
search = join('%', explode(' ', search));
search now = John%Smith
*/

A) Why is your ID field TEXT?
B)
SELECT MAX(CAST(id AS DECIMAL)) as id FROM object

Show your current query and we can walk you through what to fix.

When an index is created it takes up space on the filesystem. So as long as you're fine with taken up more space to get more speed indices are the way to go.

Make sure you have indices on the column you're searching, that's probably the easiest way to speed things up but it's a size vs. speed trade-off.

Going directly to the documentation usually helps:
http://dev.mysql.com/doc/refman/4.1/en/user-account-management.html

Like I said, what is the data type for that field?

hopefully you have a WHERE clause in that query and what is the datatype of that field?

MySQL Query Browser directly from MySQL http://dev.mysql.com/downloads/gui-tools/

As far as I know there's no way to halt a SELECT statement mid-query. You'd either have to write a stored procedure or have whatever language you're using to interact with MySQL handle this logic.

This depends on the database engine you're currently using. By default MySQL uses MyISAM (Also uses MyISAM internally). However, MyISAM only supports table-level locking so when you're writing it...

http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html Use the language documentation before going to the forums please.

Give me a real-world example of what you want because you're sort of all over the place on how you want the query to work. You really only have a few options


-- LIKE matches...

You might be able to do
WHERE user_role IN ('A', 'S', 'D')

This should be in the PHP forum, but at the same time it should not be. Read the FAQ in the PHP forum before you post again.