How do I find products when a user types freeform strings like 'Sony 20 TV' or '20 Sony TV'?

I'm having trouble figuring out the logic/query I want. I know that all those ORs are not right. I'm doing this in PHP and mySQL (of course), so if it can't be done with a single query, I can split it up. Here's the challenge, given a text field search box, someone enters: Sony 20 TV

Re: How do I find products when a user types freeform strings like 'Sony 20 TV' or '20 Sony TV'?

On Fri, May 4, 2007 10:21, Daevid Vincent wrote: I'm having trouble figuring out the logic/query I want. I know that all those ORs are not right. I'm doing this in PHP and mySQL (of course), so if it can't be done with a single query, I can split it up. Here's the challenge, given a text

Object-Oriented database

Is there such thing call Object-Oriented database for mysql? Basically can I store an item as an object in myql? - Looking for earth-friendly autos? Browse Top Cars by Green Rating at Yahoo! Autos' Green Center.

Re: Object-Oriented database

You can store any object as blob, but that's not a good idea (unless object is atomic in terms of your application). If you want to refer to your data in object-oriented manner, you can use one of the ORM pattern implementations on the client sise. As for a separate data type, no, MySQL doesn't

Re: expire_logs_days

Baron Schwartz wrote: I will test again on my servers now that I have upgraded to 5.0.38. One question for people for whom expire_logs_days DOES work: do you have any slaves connected to the server? I did not within my test. I could easily add that if need be however.. Let me know if your

Re: How do I find products when a user types freeform strings like 'Sony 20 TV' or '20 Sony TV'?

Hi Daevid, Daevid Vincent wrote: I'm having trouble figuring out the logic/query I want. I know that all those ORs are not right. I'm doing this in PHP and mySQL (of course), so if it can't be done with a single query, I can split it up. Here's the challenge, given a text field search box,

RE: secure port 3306

Thank You so much. I will have to try this later today. I have never done a port forward in iptables before. I knew that I could, but just never had a need or tried so it slipped my mind about this. Again, Thank You. Steve On linux, one could do a port forward: EXTIF=eth0 # Or

Re: expire_logs_days

Mark Leith wrote: Baron Schwartz wrote: I will test again on my servers now that I have upgraded to 5.0.38. One question for people for whom expire_logs_days DOES work: do you have any slaves connected to the server? I did not within my test. I could easily add that if need be however..

RE: Object-Oriented database

If you serialize the object, you can store it in the data base as a blob. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: sam rumaizan [mailto:[EMAIL PROTECTED] Sent: Friday,

Fwd: expire_logs_days

-- Forwarded message -- From: Jake Peavy [EMAIL PROTECTED] Date: May 4, 2007 7:41 AM Subject: Re: expire_logs_days To: Baron Schwartz [EMAIL PROTECTED] On 5/4/07, Baron Schwartz [EMAIL PROTECTED] wrote: Mark Leith wrote: Baron Schwartz wrote: I will test again on my servers

Re: expire_logs_days

Hi, Jake Peavy wrote: On 5/4/07, Baron Schwartz [EMAIL PROTECTED] wrote: Mark Leith wrote: Baron Schwartz wrote: I will test again on my servers now that I have upgraded to 5.0.38. One question for people for whom expire_logs_days DOES work: do you have any slaves connected to the server?

Re: Can't find file: 'general_log'

Hi Joseph, Joseph Koenig wrote: Hi, I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I moved the data directory of MySQL. I updated everything that SELinux complained about, etc., and have a functional install of MySQL. It's actually been up and running with no issues for

Re: expire_logs_days

Baron Schwartz wrote: I think we've found the bug. I just did a bunch of tests and I'm 99% sure not only does expire_logs_days not work if there are slaves attached, neither does PURGE MASTER LOGS. When I read my email this morning, Nagios alerted me the master server was over the expected

Re: Can't find file: 'general_log'

Hi Joseph, Joseph Koenig wrote: Hi, I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I moved the data directory of MySQL. I updated everything that SELinux complained about, etc., and have a functional install of MySQL. It's actually been up and running with no issues

Re: Can't find file: 'general_log'

Hi, CA Lists wrote: Hi Joseph, Joseph Koenig wrote: Hi, I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I moved the data directory of MySQL. I updated everything that SELinux complained about, etc., and have a functional install of MySQL. It's actually been up and running

Re: Can't find file: 'general_log'

Baron Schwartz wrote: Hi Joseph, Joseph Koenig wrote: Hi, I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I moved the data directory of MySQL. I updated everything that SELinux complained about, etc., and have a functional install of MySQL. It's actually been up and running

Re: Can't find file: 'general_log'

Hi, CA Lists wrote: Hi Joseph, Joseph Koenig wrote: Hi, I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I moved the data directory of MySQL. I updated everything that SELinux complained about, etc., and have a functional install of MySQL. It's actually been up and

multilanguage web application with mysql database?

I have many tables like the table Person:below, in mysql database. person_id, first_name,last_name, mi, gb_first_name, gb_last_name, b5_first_name, b5_last_name, gender, dob where different columns storing strings in different encodings. At anytime, a web user can switch the language and the

RE: multilanguage web application with mysql database?

Are all of your fields using the UTF8 character set? I think that's necessary. We use UTF8 and have stored Chinese characters successfully using UTF8 with a PHP web application. (At least, they look right to me - I don't know Chinese at all.) Regards, Jerry Schwartz Global Information

BEFORE trigger abd REPLACE

We have come across an interesting anomoly in MySQL behaviour in the course of our investigations. It seems that when A table is equiped with both BEFORE INSERT and BEFORE DELETE triggers and a REPLACE statement is used against that table, the INSERT trigger is fired first and the DELETE trigger

RE: Object-Oriented database

This really isn't what he's talking about - rather than storing data as rows and tables, you store as objects and methods. MySQL does not support this; you can get this sort of functionality using something like Hibernate (an Object-Relational-Mapping tool), which is free but has a learning

Re: Can't find file: 'general_log'

Baron Schwartz wrote: Hi Joseph, Joseph Koenig wrote: Hi, I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I moved the data directory of MySQL. I updated everything that SELinux complained about, etc., and have a functional install of MySQL. It's actually been up and

Re: expire_logs_days

On 5/4/07, Baron Schwartz [EMAIL PROTECTED] wrote: Hi, Jake Peavy wrote: On 5/4/07, Baron Schwartz [EMAIL PROTECTED] wrote: Mark Leith wrote: Baron Schwartz wrote: I will test again on my servers now that I have upgraded to 5.0.38. One question for people for whom expire_logs_days

Re: expire_logs_days

Hi, Jake Peavy wrote: On 5/4/07, Baron Schwartz [EMAIL PROTECTED] wrote: Hi, Jake Peavy wrote: On 5/4/07, Baron Schwartz [EMAIL PROTECTED] wrote: Mark Leith wrote: Baron Schwartz wrote: I will test again on my servers now that I have upgraded to 5.0.38. One question for people for

Re: multilanguage web application with mysql database?

I have many tables like the table Person:below, in mysql database. person_id, first_name,last_name, mi, gb_first_name, gb_last_name, b5_first_name, b5_last_name, gender, dob where different columns storing strings in different encodings. All the strings/fields etc. need to be in the *same*

indexing order column

hi, if I have column order_id(int(4)) null do I have to index it too. I'm going to use it ONLY for sorting records. thanks. -afan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Order By and Ignore Punctuation

Try something like this. If there are multiple punctuation values you want to ignore you can nest multiple REPLACE functions. mysql create table names (name varchar(20)); Query OK, 0 rows affected (0.01 sec) mysql insert into names values ('Osbourn'),(O'shea),(O'Malley),('Olathe'),('Ottawa');

Re: indexing order column

Hi Afan, Afan Pasalic wrote: hi, if I have column order_id(int(4)) null do I have to index it too. I'm going to use it ONLY for sorting records. It depends a lot on how much data is in the table, etc etc. An index will make sorting more efficient in the general case when you have a decent

Re: indexing order column

Baron Schwartz wrote: Hi Afan, Afan Pasalic wrote: hi, if I have column order_id(int(4)) null do I have to index it too. I'm going to use it ONLY for sorting records. It depends a lot on how much data is in the table, etc etc. An index will make sorting more efficient in the general

Re: indexing order column

Hi, Afan Pasalic wrote: Baron Schwartz wrote: Hi Afan, Afan Pasalic wrote: hi, if I have column order_id(int(4)) null do I have to index it too. I'm going to use it ONLY for sorting records. It depends a lot on how much data is in the table, etc etc. An index will make sorting more

Re: indexing order column

Baron Schwartz wrote: Hi, Afan Pasalic wrote: Baron Schwartz wrote: Hi Afan, Afan Pasalic wrote: hi, if I have column order_id(int(4)) null do I have to index it too. I'm going to use it ONLY for sorting records. It depends a lot on how much data is in the table, etc etc. An index

RE: How do I find products when a user types freeform strings like 'Sony 20 TV' or '20 Sony TV'?

-Original Message- From: Baron Schwartz [mailto:[EMAIL PROTECTED] Daevid Vincent wrote: I'm having trouble figuring out the logic/query I want. I know that all those ORs are not right. I'm doing this in PHP and mySQL (of course), so if it can't be done with a single query, I

Re: How do I find products when a user types freeform strings like 'Sony 20 TV' or '20 Sony TV'?

Hi Daevid, Daevid Vincent wrote: -Original Message- From: Baron Schwartz [mailto:[EMAIL PROTECTED] Daevid Vincent wrote: I'm having trouble figuring out the logic/query I want. I know that all those ORs are not right. I'm doing this in PHP and mySQL (of course), so if it can't be

slave replication fails, cannot create user

I'm transitioning from one mysql server to another, in production use, by setting the new server up as a slave, so that when it's time to switch, we'll have very little downtime. Then we can turn off replication and the new slave will become the new production server. I set up a replication

Re: slave replication fails, cannot create user

Hi, Ofer Inbar wrote: I'm transitioning from one mysql server to another, in production use, by setting the new server up as a slave, so that when it's time to switch, we'll have very little downtime. Then we can turn off replication and the new slave will become the new production server. I

Re: slave replication fails, cannot create user

Baron Schwartz [EMAIL PROTECTED] wrote: What version of MySQL are you running on each machine? Sorry, I should've included this information. Both of them are running 5.0.24, installed from exactly the same .rpm file. I wanted to avoid any issues related to different MySQL versions during this

Re: slave replication fails, cannot create user

Ofer Inbar wrote: Baron Schwartz [EMAIL PROTECTED] wrote: What version of MySQL are you running on each machine? Sorry, I should've included this information. Both of them are running 5.0.24, installed from exactly the same .rpm file. I wanted to avoid any issues related to different MySQL