> I get incorrect result when searching for the norwegian character 'å'
> using LIKE. I get rows with 'a' in it, and visa versa if I search for
> 'a', I get results which has 'å' in it in addition to the ones with 'a'.
Make sure that your table has:
charset=utf8
collation=utf8_norwegian_ci
A
Dear List,
I get incorrect result when searching for the norwegian character 'å'
using LIKE. I get rows with 'a' in it, and visa versa if I search for
'a', I get results which has 'å' in it in addition to the ones with 'a'.
Example:
CREATE TABLE names (
name VARCHAR(255)
)ENGINE=InnoDB DEFA
Exporting and then importing the table helped, now both the regexp and the
like query produce the same result. I saved the table MYI file and will
keep experimenting with it, maybe I can come up with something useful.
Thanks for the idea.
Zoltan
On Fri, 18 Nov 2005, Scott Haneda wrote:
on 1
on 11/18/05 7:18 AM, Peczöli Zoltán at [EMAIL PROTECTED] wrote:
> The result of the second query matches that of the corresponding LIKE
> query, but the first seems to be correct.
>
> Any ideas what the problem might be?
You are getting strange results. At this point I would suggest dumping the
I tried to investigate my previous problem with statements containing LIKE
clause on a specific table. The problem was basically the following:
mysql> SELECT count(*) FROM user WHERE username LIKE 'o%';
+--+
| count(*) |
+--+
|0 |
+--+
1 row in set (0.00 sec)
m
Hello.
Really, seems a bit weird for me. I suggest you to check your
'character_set_xxx' variables to be sure that there're no
unnecessary translations from one encoding to another. If you're
able to make a small repeatable test case, install on your Debian
server second instance of MySQL (u
select count(*) from user where username like 'a%';
select count(*) from user where username not like 'a%' or username is null;
is not the same for all letters of the alphabet:
letter like not-like sum
n 2304 59317 61621
o 0 60797 60797
p 3048 58573 61621
Sounds like a
Hi,
Moreover, the sum of the results of these two queries
select count(*) from user where username like 'a%';
select count(*) from user where username not like 'a%' or username is null;
is not the same for all letters of the alphabet:
letter like not-like sum
n 2304 59317 61621
o
Recently I ran into a problem with 'LIKE' in mysql on Debian Sarge:
mysql> select VERSION();
+---+
| VERSION() |
+---+
| 4.1.11-Debian_4sarge2-log |
+---+
1 row in set (0.00 sec)
with the following table:
CR
to:[EMAIL PROTECTED]
Sent: quarta-feira, 22 de setembro de 2004 04:27
To: [EMAIL PROTECTED]
Subject: Like - Problem
Hello there,
I was wondering how I could make a specific type of search when the string
has more than one word.
Ex.-
String
This is the third time you have asked this, and it has been answered twice.
Once is enough.
Rui Monteiro wrote:
Hello there,
I was wondering how I could make a specific type of search when the string
has more than one word.
Ex.-
String = "Green Apple"
Hello there,
I was wondering how I could make a specific type of search when the string
has more than one word.
Ex.-
String = "Green Apple"
Select * from fruits
where
(fruits.color like '%Green Apple%'
or fruits.type like '%Green App
gust 29, 2002 2:08 PM
Subject: Re: like problem
> How about
>
> select a.name from table1 a, table2 b where a.name like
> concat("%",b.name,"%");
>
> You might want to read chapter 6.3 in the mysql manual:
> http://www.mysql.com/doc/en/Functions.html
>
>
OTECTED]>
To: Jorge Martinez <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 1:52 PM
Subject: RE: like problem
>
>
> ok try this
> select a.name from table1 a, table2 b where a.name like
> '%'+ b.name + '%';
>
>
&
ct a.name from table1 a, table2 b where a.name like
> '%'b.name'%';
>
> is an error
>
>
> - Original Message -
> From: Mary Stickney <[EMAIL PROTECTED]>
> To: Jorge Martinez <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent:
NY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Jorge Martinez" <[EMAIL PROTECTED]>
To: "Mary Stickney" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, Augu
ok try this
select a.name from table1 a, table2 b where a.name like
'%'+ b.name + '%';
-Original Message-
From: Jorge Martinez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 11:48 AM
To: Mary Stickney; [EMAIL PROTECTED]
Subject: RE: like problem
ye
yes, but select a.name from table1 a, table2 b where a.name like
'%'b.name'%';
is an error
- Original Message -
From: Mary Stickney <[EMAIL PROTECTED]>
To: Jorge Martinez <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, August 29,
that would be because b.name is inside the ' ' and it is taken as a
constant.
-Original Message-
From: Jorge Martinez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 11:10 AM
To: [EMAIL PROTECTED]
Subject: like problem
i need this consult
select a.name fro
i need this consult
select a.name from table1 a, table2 b where a.name like '%b.name%';
but i have a problem because Mysql not recognize the value of b.name
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi!
I use a query : SELECT * FROM Table1 WHERE name LIKE "K%" (K = Greek char =
ASCII 137)
but it selects also "k" (small K Greek) and "L" (Greek , ASCII 138)
Why so and what I have to do? Something is in Apache setup?
Also is there a way to print a counter at first row intead of ID
(autoincrem
, February 09, 2002 3:07 AM
To: MySQL list (E-mail)
Subject: a LIKE problem ecc.
Hi!
I use a query : SELECT * FROM Table1 WHERE name LIKE "K%" (K = Greek char =
ASCII 137)
but it selects also "k" (small K Greek) and "L" (Greek , ASCII 138)
Why so and what I have
Hi!
I use a query : SELECT * FROM Table1 WHERE name LIKE "K%" (K = Greek char =
ASCII 137)
but it selects also "k" (small K Greek) and "L" (Greek , ASCII 138)
Why so and what I have to do? Something is in Apache setup?
Also is there a way to print a counter at first row intead of ID
(autoincrem
23 matches
Mail list logo