How to: Include identifier with a query

From: Date: Mon, 02 Nov 2009 13:16:23 +0000
Subject: How to: Include identifier with a query
Groups: php.db 
Request: Send a blank email to php-db+get-46613@lists.php.net to get a copy of this message
Greetings! We are searching for names that might or might not exist in a 4 million row db and have to do a lot of fuzzy searches that often don't return results. I would like the use to have the option of killing a query process. Since we are apt to have several queries running KILL QUERY doesn't seem to work. I would like to use KILL (process id) instead. We can use SHOW FULL PROCESSLIST to get a complete list of the processes, but we need for the code to identify which one to kill. Here's the question: How can I "flag" a particular query so it can be identified from the array SHOW FULL PROCESSLIST generates? Thanks! - Ron

« previous php.db (#46613) next »