MAX select problem

Hello, I'm trying to get the date and amount of the most visits to my site over a given time period using : SELECT max(visits) as maximum FROM visit WHERE (((visit_date >= '$sdatestring') and (visit_date < '$edatestring')) and (site_id=$site_id)) This gives me the right figure, but when I try to

BOOLEAN Vs NON-Boolean

Hello, I've just upgraded to 4.1 for boolean search facilities, but I think I may lose more than I 've gained. I just really need the "+keyword1 keyword2" functionality so all results must contain keyword1, but I then need to order by relevance score which I've lost. Is it worth performing two n

Simple GROUP / ORDER problem

Hello, If got a simple sessions table basically holds a session id and datetime field for last modification also a session type, so I can have several records with the same session id, with different types and different modification time. I want to get the latest modified record for any given sess

Re: Character Set Problem

Is it possible to change the character set just for an individual table and if so which character set should I try to display this european characters? Cheers, Lee - Original Message - From: "Sumito_Oda" <[EMAIL PROTECTED]> To: "Lee Denny" <[EMAIL PROTECTED

Character Set Problem

Hello, this is probably quite simple but I've got a text file that has non-english characters, when I view it I see : 'Découvrez un réseau européen d'hôtels et de restaurants beignant dans une atmosphère conviviale et familliale' I've imported this straight into my myisam DB which is set up

Duplication of records within the same table.

Hello, I've got a table with a simple structure: site_id, page_id,header_text,main_text.. I just need to duplicate existing records with a new site_id, so : 1,1,Hello,some text.. 1,2,Hello Again, some more text... gets copied to 2,3,Hello,some text.. 2,4,Hello Again, some more text... page_i

Fulltext search Strategy - Need Help

Hello, I'm doing fairly straight forward fulltext searches, but I want to nest them - basically do a keyword search on 'phrase 1' and then search the results this returns for 'phrase 2', for example if phrase 1 is 'ford' and phrase 2 is 'focus' - I search once for 'ford' and then go through the re

Tricky Date Query

Hello, I need to perform a select that compares two dates I need to return all records that haven't had date_2 set after a given number of days since date_1. I'm sure this can be done in one query but I just can't get my head around this one. Can anyone help? Cheers, Lee -- MySQL General M

Notifying User when DB is Updated via browser

atest applications. Is there any way of using some sort client-server technology to alert the user, via the browser that a new entry has appeared in the DB - I'm already sending an email but this is still not the best solution. Thanks in advance, Lee Denny -- MySQL General Mailing Lis

Database Design and Bianry Operations

is a more efficient method using binary operations (only one field populated with zeros and ones) but I can't find anything to help in the manuals. Any thoughts? Lee Denny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

JDBC problems

I'm trying to use the mm.mysql JDBC drivers on windows NT I've just downloaded the mysql-connector-java-2.0.14.zip file and extracted it into my jdk1.2.2/jre/lib/ext folder. I try to connect with import java.sql.*; public class dbconnect { public static void main(String[] args) { String ur

Perl DBI

Hi, How can i use Perl DBI to create tables in mysql? Denny __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yaho

Migration to MySQL from flatfiles

d I need to consolidate to a single auth source Can anyone point me in the right direction? Denny Snyder Network Engineer Susquehanna Communications 1050 E. King St York, PA 17403 Office: (717)771-2613 Fax:(717)843-5400 [EMAIL PROTECTED] [EMAIL PROTECTED] "Nothing in life is worse t

mysql with java

Hi, Is there any examples on developing a java interface with mysql? Thanks, Denny - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Speed problem with sorted select statements

NULL | 3418459 | where used; Using index; Using temporary; Using filesort | +---+---+-+--+-+ --+-+--+ 1 row in set (0.00 sec) Fix: Synopsis: Speed problem with sorted select statements Sub

Quick REGEXP problem

Hello, Can any one tell me why $sql="SELECT * FROM table WHERE pcsort REGEXP '^".$parts[0]."[0-9]'"; (pcscot being a CHAR(10), $parts[0] being a single alpha charcater.) works OK in 3.23 but not in 3.22. I'm trying to find UK postcodes such as e17 but not ee17. All the best, Lee --

Error in installing mysql

Hi, I am new to linux and i currently trying to install mysql on my redhat 7.1. I always got this error message at the end of the make "Internal error: Segmentation fault.". I wonder if anyone would tell me what's going on? My machine is running on cyrix P133 with 32MB ram.