Mysql Regular expression

Hi Can any body tell me how to strip all the html characters from a text column while querying? Thanks Binay

Re: how to randomnly select just 1 record from the table?

well i have only 4 records in the table. When i use below mentioned query it always return the same record irrespective of time delay. Now wht can i do? Thanks Binay > "Binay" <[EMAIL PROTECTED]> wrote on 21/06/2004 15:03:34: > > > > I need to select randomnly

how to randomnly select just 1 record from the table?

Hi all I need to select randomnly just one record from the table. how can i do? please help me out. Thanks in advance binay

Re: Last inserted id

Thanks Mark... You popped me out of great confusion/problem. Binay - Original Message - From: "Mark Maunder" <[EMAIL PROTECTED]> To: "Binay" <[EMAIL PROTECTED]> Cc: "mysql users" <[EMAIL PROTECTED]> Sent: Thursday, February 19, 2004 3:03

Last inserted id

operation starts .. so ultimately mysql_insert_id will fetch 2nd insert operation id which should not be the case. How to resolve this case?? Thanks Binay

Re: Locking the tables

Hi Andrey, many thanks for quick response. plz find my further query below. - Original Message - From: "Andrey Subbotin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 19, 2003 12:27 PM Subject: Re: Locking the tables > > Hello Binay. &g

Locking the tables

advance Binay

Re: How to create mysql user?

try restarting mysql service .. Cheers Binay - Original Message - From: "ads mysql" <[EMAIL PROTECTED]> To: "Duke, Brian" <[EMAIL PROTECTED]>; "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, December 16, 2003 2:07 PM S

Mysql user

Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay

Importing data

Hi all, How can i import table structure and data which is there in a text file to database say test_database using phpmyadmin. I m asking using phpMyadmin as i don have shell access and hence can't use mysql commands. Plz help me ... its very urgent .. Thanks in advance Binay

Mysql user

Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay

Mysql user

Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay

Mysql backup problem

each database . is it possible to copy the particular folder(database) to 3.23.58 and then running it smoothly ... Any body got any idea ??? Please help me out.. Thanks in advance Binay

Records Mysql can handle??

Hi All, Can any body tell me how many records mysql can hold efficiently. i.e Is there any boundation on number of records mysql can handle? Please let me know ... Thanks Binay

Just testing please ignore

Testing ..Please ignore this email

Re: Quick ones to speed up acces!

In my earlier post i forgot to mention about limit,10,20 to be added in query. - Original Message - From: "Binay Agarwal" <[EMAIL PROTECTED]> To: "Roger Davis" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, August 11, 2003 5:22 AM Sub

Re: Reading table structure and data from sql file.

Thanks Nils Binay - Original Message - From: "Nils Valentin" <[EMAIL PROTECTED]> To: "Binay Agarwal" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, August 13, 2003 12:24 PM Subject: Re: Reading table structure and data from sql file. &

Sppeding up on ORed coloumns query

7; it has to be '%blah%' only... (i.e balh can be even middle part of the words) Table contains 50,000 records and queries taking 7 sec which is unbelievable. Mysql version: 3.23.52 Please suggest me some solution for this. Thanks in advance Binay

Quick ones to speed up acces!

an be applied to this database which hasn't been touched since design to enhance the spped. If there are some quick ones but valued alottt please let me know. Thanks in advance Binay

Reading table structure and data from sql file.

Hi everybody, I have backed(backup.sql) up one Mysql database which contains 10 tables using mysqldump. Now I want to read just one table structure and it's data from backup.sql to another database. How do i achieve it. I have tried "mysql databasename < backup.sql" but it will populate

Re: Reading table structure and data from sql file.

Hi Nils , Thanks for quick reply. I know already about the selective Backup using mysqldump and then use it. But what i want is restoring the selective backup i.e restore just one table out of say 10 tabels structure and data. Binay - Original Message - From: "Nils Valentin&quo

just testing

Testing ..Please ignore this email

Re: Quick ones to speed up acces!

headline like '%blah%' or cat like '%blah%' Please help me out. Binay - Original Message - From: "Roger Davis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 11, 2003 4:57 PM Subject: RE: Quick ones to speed up acces! > I

Re: Quick ones to speed up acces!

Thanks alot roger. Right now i m going through the indexes and Full text search stuff. I'll surely let u know any improvement in the performance after i m done. Binay - Original Message - From: "Roger Davis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent