Re: mysql search count

2007-10-07T19:25:37-04:00

If I search someting in the mysql db, after the results it shows someting like:
1 row in set (0.07 sec)
Is there a way to use that info, so it can be announced in the irc channel?

What i am looking for is the count of the result that it found and show that in the channel.

I al ready tried it with:
Code:
select count(*) from $table WHERE search like '%$search%';
That works, but if the search is in the db a lot, it is slow.
So I thougth way do I need this code if its already shown after the search is done.

Is this possible? Or maybe some1 else know a better and faster way?

thanks

for example: use SELECT (with rows, not count(*)) and then SELECT FOUND_ROWS() below to see number of matches. there is more ways how to do that, if i got correctly what you want to do

Statistics: Posted by dwickie — Sun Oct 07, 2007 7:25 pm

mysql search count

2007-10-07T16:11:39-04:00

If I search someting in the mysql db, after the results it shows someting like:

1 row in set (0.07 sec)

Is there a way to use that info, so it can be announced in the irc channel?

What i am looking for is the count of the result that it found and show that in the channel.

I al ready tried it with:

Code:

select count(*) from $table WHERE search like '%$search%';

That works, but if the search is in the db a lot, it is slow.
So I thougth way do I need this code if its already shown after the search is done.

Is this possible? Or maybe some1 else know a better and faster way?

thanks

Statistics: Posted by heman — Sun Oct 07, 2007 4:11 pm

egghelp/eggheads community

Re: mysql search count

mysql search count