, check out ExcelSQL! - see http://www.excelsql.com -
-Original Message-
From: Koh Swee Meng [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 6:07 AM
To: [EMAIL PROTECTED]
Subject: Re: select * from table where field=hex doesnt work
oh, i found the solution
At 12:31 +0900 7/8/03, Nils Valentin wrote:
Hi Koh,
Shouldn't the value in the first sample be used like this ?
1) SELECT * FROM table1 WHERE field1 = '0x6100620063006400';
Correct me if I am wrong.
You're wrong. :-)
0x6100620063006400 is a hex literal, which will be treated as
a
Hi Paul,
2003 7 9 11:17Paul DuBois :
At 12:31 +0900 7/8/03, Nils Valentin wrote:
Hi Koh,
Shouldn't the value in the first sample be used like this ?
1) SELECT * FROM table1 WHERE field1 = '0x6100620063006400';
Correct me if I am wrong.
You're wrong. :-)
0x6100620063006400
oh, i found the solution for this,
by doing SELECT * FROM table1 WHERE STRCMP(field1,
0x6100620063006400)=0 will work as expected, so no need to worry that
character %(ASCII 25) will cause any problem.
Regards,
Koh Swee Meng
- Original Message -
From: Koh Swee Meng [EMAIL
Hi Koh,
Shouldn't the value in the first sample be used like this ?
1) SELECT * FROM table1 WHERE field1 = '0x6100620063006400';
Correct me if I am wrong.
Best regards
Nils Valentin
Tokyo/Japan
2003 7 8 11:55Koh Swee Meng :
i inserted a new record with this SQL
INSERT INTO
At 05:10 PM 12/9/2002 -0500, Beauford.2003 wrote:
I mentioned in my previous email that I am using PHP, and I have also tried
putting quotes around $var (many different ways) with no better results.
REGEXP just gives a syntax error when I do this.
Below is an example of using PHP and MySQL with
Hello.
On Mon 2002-12-09 at 01:00:33 -0500, [EMAIL PROTECTED] wrote:
I am doing this search from a website,
What does that mean? Which scripting language do you use? PHP? This is
more a question for your website environment than about MySQL.
and from what I can tell there is no way to use a
, but it does
not cover this.
- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Beauford.2003 [EMAIL PROTECTED]
Cc: Robert Citek [EMAIL PROTECTED]; MySQL List
[EMAIL PROTECTED]
Sent: Monday, December 09, 2002 3:30 AM
Subject: Re: Select * From table where name Like 'help
-
From: Jocelyn Fournier [EMAIL PROTECTED]
To: Beauford.2003 [EMAIL PROTECTED]
Sent: Monday, December 09, 2002 9:31 AM
Subject: Re: Select * From table where name Like 'help'; Help
No it doesn't, since I introduce a space between % and one. So stone
will
not be returned :)
Regards,
Jocelyn
3:08 PM
Subject: Re: Select * From table where name Like 'help'; Help
You still have not mentioned what language you are using to interface
with MySQL. If you are using PHP or Perl, then things like single and
double quotes will make a difference here, and looking in the MySQL
manual
This is most definitely a quoting issue with your PHP string. If it is
quoted correctly, the MySQL server will never see the string $var
appearing after the keyword REGEXP, so if $ has meaning to a regular
expression wouldn't matter (unless the value of $var contained a $).
I've used REGEXP
[EMAIL PROTECTED]
Sent: Monday, December 09, 2002 3:30 AM
Subject: Re: Select * From table where name Like 'help'; Help
Hello.
On Mon 2002-12-09 at 01:00:33 -0500, [EMAIL PROTECTED] wrote:
I am doing this search from a website,
What does that mean? Which scripting language do you
On Mon, 2002-12-09 at 16:10, Beauford.2003 wrote:
Andy,
I mentioned in my previous email that I am using PHP, and I have also tried
putting quotes around $var (many different ways) with no better results.
REGEXP just gives a syntax error when I do this.
I'm sorry, I did miss the where you
Hello.
On Mon 2002-12-09 at 09:22:09 -0500, [EMAIL PROTECTED] wrote:
I am using PHP on my website, but this is certainly a MySQL question.
That shouldn't matter, because the real value $var is inserted before
the query is send to the MySQL server, where REGEXP of the query is
evaluated.
Hi,
A dirty solution would be to search :
field LIKE '% one %' or field LIKE 'one %' or field LIKE '% one' or
field='one';
Regards,
Jocelyn
- Original Message -
From: Beauford.2003 [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Tuesday, December 10, 2002 12:50 AM
Subject:
Try the REGEXP modifier. For example:
mysql select Another One regexp [[::]]One[[::]] ;
mysql select Fashioned regexp [[::]]One[[::]] ;
The format differs from that used in sed, grep, awk, perl, python, etc.
http://www.mysql.com/documentation/mysql/bychapter/manual_Regexp.html#Regexp
PROTECTED]
To: Beauford.2003 [EMAIL PROTECTED]
Cc: MySQL List [EMAIL PROTECTED]
Sent: Sunday, December 08, 2002 8:16 PM
Subject: Re: Select * From table where name Like 'help'; Help
Try the REGEXP modifier. For example:
mysql select Another One regexp [[::]]One[[::]] ;
mysql select Fashioned regexp
Did you ever get an answer?
I played with some queries and came up with this:
SELECT ID, NAME, RATING FROM SINGLEMALTS ORDER BY RATING DESC LIMIT 0,1;
If you want more than one record, you can change the 1 at the end to how
many you want. If you want to list them all in that order, you can take
Select * from singlemalts order by rating limit 1;
Now, you have to share your samples with the rest of us! :)
Cal
http://www.calevans.com
-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 21, 2001 12:49 PM
To: [EMAIL PROTECTED]
Subject: SELECT
select max(rating) from singlemalts will give you the highest value
or
select * from singlemalts order by rating desc
will give all the rows ordered by rating and the first row will have the
highest value
Richard Reina wrote:
I've tried the manual (and the Oreily MySQL book) and played
20 matches
Mail list logo
