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
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
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
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]
Cc: mysql@lists.mysql.com
Sent
Hello,
this is probably quite simple but I've got a text file that has non-english
characters, when I view it I see :
'Dcouvrez un rseau europen d'htels et de restaurants beignant dans
une atmosphre conviviale et familliale'
I've imported this straight into my myisam DB which is set up with
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...
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
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
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 List
For list
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]
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
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
12 matches
Mail list logo