Select IP from Text Type

Im trying to select an IP from a TEXT (details) type field, which works if I do this: select id from `table` where `details` like '%192.168.0.1%' : But If I want any record with an IP in that TEXT type field it seems a little tricky. I have tried: select id from `table` where INET_ATON(details)

Select IP from Text Type

Im trying to select an IP from a TEXT (details) type field, which works if I do this: select id from `table` where `details` like '%192.168.0.1%' : But If I want any record with an IP in that TEXT type field it seems a little tricky. I have tried: select id from `table` where INET_ATON(details)

full-text search

I have a TEXT field in my db (4.0) that has lists of IP numbers; can a full-text search be done for IP numbers? If so could you show me an example query? Thanks Rob

mysql function inet_aton/inet_ntoa

I am storing ips in a mysql 4.0.17 db as int. I am Converting them using a perl script with inet_aton to create a four-byte string. My goal: Is to return the ip as a normal dotted ip for the user to see after a select statement is done via a php web page. The ip is entered in as a dotted ip on

Location of files

Is there any benefit to having the .MYD files on one drive, and the .MYI on its own dedicated hard drive?? rm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Do I need Innodb?

? On Fri, 16 Jan 2004 13:43:55 -0800 Ron McKeever [EMAIL PROTECTED] wrote: Scenario 1: I have noticed that if two users open a record to edit it in two different browsers and they edit the same field and then click update, the last user/browser gets written to the db, where the first users

Do I need Innodb?

Hi I have a web app that use's PHP/Mysql/MYISAM. I am starting to think I need INNODB table type. Scenario 1: I have noticed that if two users open a record to edit it in two different browsers and they edit the same field and then click update, the last user/browser gets written to the db,

mysqlimport question

I'm trying to use mysqimport instead of LOAD DATA INFILE from a shell script. I notice an option for mysqlimport is not working or im doing it wrong. This works with LOAD DATA INFILE : mysql -e LOAD DATA INFILE 'x' INTO TABLE x IGNORE 2 LINES but when i try: mysqlimport --ignore-lines=2

Db design

Hello, I have a db(logs) that I have been working on. This db has tables that are created every month, they are Nov03,Dec03,Jan04, etc.. Each month/table has about 480,000,000 records. Data file is about 80GB the index file is about 40GB. Mysql/apache run on a Dell 2550 4gb ram 2cpu's OS - RH 9.

unixtime update syntax

Anyone have a response to the following: Hi I have a db that gets data dumped into it. One of the columns gets unix timestamp data utime. I what to covert that into a datetime column so I can utlize indexes and such. But I still what the unixtime to remain. I know I can get the data I want with

RE: unixtime update syntax

sec) Any ideas? Ron -Original Message- From: Dan Greene [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 8:30 AM To: Ron McKeever; [EMAIL PROTECTED] Subject: RE: unixtime update syntax The time zone matters... your results are exactly 8 hours off... PST is gmt -8. So it looks

RE: unixtime update syntax

Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 8:55 AM To: [EMAIL PROTECTED] Subject: Re: unixtime update syntax On 2 Dec 2003 at 7:57, Ron McKeever wrote: I have a db that gets data dumped into it. One of the columns gets unix timestamp data utime. I

unixtime update syntax

Hi I have a db that gets data dumped into it. One of the columns gets unix timestamp data utime. I what to covert that into a datetime column so I can utlize indexes and such. But I still what the unixtime to remain. I know I can get the data I want with php or mysql to convert it, but I need

RE: create own auto increment number

Chris, Thats not what i think im Asking. I was wondering if its possible to have a AUTO_INCREMENT ID number also have the format mmddyy. So when you query the table it would be the PRIMARY KEY AUTO_INCREMENT ID field: select * from table: name email phone ID Bugs

Column type

Hi I have a .txt file that is loaded into my table. This is done using LOAD DATA INFILE One of the columns data is a unix timestamp from the .txt file. The column is called begin. I have created the column as a varchar before and then converted the date using FROM_UNIXTIME(), so it can be

Update table with UNIX_TIMESTAMP

Hello I have a table that gets appended to every night with the LOAD DATA command. The column 'start' is a unix timestamp. So when the LOAD DATA is done I then want to update the Column to be human readable. I was thinking of the following: UPDATE table SET start = UNIX_TIMESTAMP(start); I