REGEXP help Finding phone numbers (nnn) nnn-nnnn format

Hi, Please, can anyone lend a hand in helping pullout phone numbers from the DB that only match the format (nnn) nnn- ? SELECT phone_work FROM leads WHERE phone_work REGEXP 'the_expression?' I've been trying to lick this for hours now with no avail. Thank you, Paul -- MySQL Gen

Could somebody tell me how to use the memcache engine inside mysql?

Although I set up memcache engine successfully on my computer, I didn't know how to use it? I can not find where the document is. Here is my result of engines. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11 Server version: 5.1.30 Source distribution Type

log_output variable

hi guys,   mysql> show variables like '%output%'; +---+---+ | Variable_name | Value | +---+---+ | log_output    | FILE  | +---+---+ 1 row in set (0.00 sec) mysql> set global log_output=table; ERROR 1064 (42000): You have an error in your SQL syntax; c

Cache Hosts - Which are tempting max_connect_errors?

Hi, Is there a way in 4.X or 5.0 to tell which hosts are running up the counter towards max_connect_errors? We'd like to be able to monitor this and act accordingly? I've seen that they suggest to set it to 9 in 13.5.5.2 FLUSH Syntax to avoid it. I'm just wondering why they didn't

Re: create single resultset from multiple sets

Hi Bryan, My gut reaction would be to use a temporary table - create the temporary table at the start of proc1, run multiple inserts into the temp table for the results of proc2, then just before proc1 ends, select from the temp table and drop it. Andy Cantwell, Bryan wrote: I have a proce

create single resultset from multiple sets

I have a procedure (proc1) that calls another procedure (proc2) several times. I'd like to make proc1 return the proc2 results in a single resultset. How can this be done in mysql 5.0.51? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

[Q] FULLTEXT index question

Can one make a composite index with FULLTEXT for one column and standard indexing on another? For instance we have a table CREATE TABLE OurData ( TheText TEXT, TheLanguageID INTEGER ); We have a FULLTEXT index on TheText, but want to be able to do searches on TheText AND TheLanguage

Re: MySQl and LVM

Simon, Thanks for the info, that is very useful. I still have a few questions though...I am considering setting up a 200GB LVM partition for the mysql data and a 70 GB LVM partition for the snapshots. Am I able to store several snapshots on the 70 GB partition? or do I need to take one snapsh

Fwd: Updating from MySQL 4.0.12 to 5.0.67 Community

Crap. The list won't let me send the graphic through, and I can't host it anywhere ATM. When I run winmysqladmin.exe it comes up with a gui showing that it's version 1.4 and that's where it asks for a user/pass and says it's creating a my.ini -- Forwarded message -- From: Bai She

MySQL University session on December 4: What's new in MySQL optimizer

This Thursday (December 4th), Sergey Petrunia will highlight what's new in MySQL Optimizer, with a focus on MySQL 5.1. Since Sergey is one of the main developers in charge of MySQL Optimizer, you can expect to get some in-depth insights that only very few people could provide. The session will sta