Hi mysql-list,
1.
my installation:
[EMAIL PROTECTED]:~> uname -a
Linux rosetta 2.4.19-4GB #1 Fri Sep 13 13:14:56 UTC 2002 i686 unknown
[EMAIL PROTECTED]:~>
mysql> show global variables like "version";
+---++
| Variable_name | Value |
+---+--
sean peters <[EMAIL PROTECTED]> wrote:
> Hi all, I am wondering if there is a way to transform the following query
> using LIKE & OR into a query using IN, where the IN ( list) contains wildcard
> expressions.
>
> initial query:
> SELECT ID FROM address WHERE Street_Name LIKE "first%" OR Street_
Hi all, I am wondering if there is a way to transform the following query
using LIKE & OR into a query using IN, where the IN ( list) contains wildcard
expressions.
initial query:
SELECT ID FROM address WHERE Street_Name LIKE "first%" OR Street_Name LIKE
"second%"
desired format would be somet
yes, but then you wouldn't learn. if you don't want to buy Dubois' book,
try appendix J of the mySql reference manual, available for free from the
mysql site.
At 06:06 PM 7/26/01 +0100, you wrote:
>In message <[EMAIL PROTECTED]>, tj marlin
><[EMAIL PROTECTED]> writes
>>I think it is time for
In message <[EMAIL PROTECTED]>, tj
marlin <[EMAIL PROTECTED]> writes
>I think it is time for you to learn about regular expressions; page 520
>ff of Dubois.
>(sql, mysql, database - to get past the filter)
>
any chance of an example or full syntax?
M.
--
Work:- postmasterAThinwick.demon.co
I think it is time for you to learn about regular expressions; page 520 ff
of Dubois.
(sql, mysql, database - to get past the filter)
At 01:14 AM 7/26/01 +0100, you wrote:
>Hi all,
>
>I have a problem, I have some VARCHAR data in a column called Sequence
>looking like this:-
>
>5;6
>12;6
I think it is time for you to learn about regular expressions; page 520 ff
of Dubois.
(sql, mysql, database - to get past the filter)
At 01:14 AM 7/26/01 +0100, you wrote:
>Hi all,
>
>I have a problem, I have some VARCHAR data in a column called Sequence
>looking like this:-
>
>5;6
>12;6
>120;
Hi all,
I have a problem, I have some VARCHAR data in a column called Sequence
looking like this:-
5;6
12;6
120;6
5;6;1
12;6;12
120;6;105
So there could be anything from 2 to n numbers seperated by ;
Each number could be 1 to 3 digits long (eg 5 12 or 121).
I have tried various searches like
It is a binary colum
-
-sherzodR
phone: (517) 774-2702
email: [EMAIL PROTECTED]
On Wed, 27 Jun 2001, Tobias Eggendorfer wrote:
> Hi,
>
> I suppose I found a bug :-)
> According to LIKE in a SELECT-query is case-insensitive. In fact,
> it is, when using it on varcha
At 11:56 PM +0200 6/27/01, Tobias Eggendorfer wrote:
>Hi,
>
>I suppose I found a bug :-)
>According to LIKE in a SELECT-query is case-insensitive. In fact,
>it is, when using it on varchars. But with a longblod, it is not.
>So if the table has column "test longblob" and there is a colum
>where te
> I suppose I found a bug :-)
> According to LIKE in a SELECT-query is case-insensitive. In fact,
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#BLOB
The only difference between BLOB and
a blob is by definition case sensitive hence 'Binary Large Object' This
is not a bug but by design, If you want a non-Binary field to store
large text objects then you should be using the 'TEXT' data type not the
'BLOB' data type.
Tobias Eggendorfer wrote:
>
> Hi,
>
> I suppose I found a bug
Hi,
I suppose I found a bug :-)
According to LIKE in a SELECT-query is case-insensitive. In fact,
it is, when using it on varchars. But with a longblod, it is not.
So if the table has column "test longblob" and there is a colum
where test is set to "xxAbcdx", the query SELECT *
FROM
13 matches
Mail list logo
