like in()

Hi, I can do: where word in('one','two','three') and I can also do: where word like 'thr%' Is there a way of combining these 2 ways? I want to select something like: where word like 'on%' or word like 'tw%' or word like 'thr%' but using a single expression, without "or". Is it possible to

Re: CREATE TABLE LIKE in MySQL 3.23

Jigal van Hemert spill.nl> writes: > http://dev.mysql.com/doc/mysql/en/show-create-table.html > > Use output of SHOW CREATE TABLE, modify name and execute that query. Superb solution. I didn't know that MySQL has such a command. My question was very basic. Sorry for bothering. Best regards, K

Re: CREATE TABLE LIKE in MySQL 3.23

Konrad Billewicz wrote: Hello, I would like to do thing exactly like CREATE TABLE a LIKE b. But... I have MySQL 3.23 and this command is available since 4.1. How would you handle this task using this, older MySQL? http://dev.mysql.com/doc/mysql/en/show-create-table.html Use output of SHOW C

CREATE TABLE LIKE in MySQL 3.23

Hello, I would like to do thing exactly like CREATE TABLE a LIKE b. But... I have MySQL 3.23 and this command is available since 4.1. How would you handle this task using this, older MySQL? Best regards, Konrad Billewicz -- MySQL General Mailing List For list archives: http://lists.mysql.c

Re: international LIKE in 4.1.1-alpha

"Juri Shimon" <[EMAIL PROTECTED]> wrote: >> I was able to repeat it on 4.1.1 but your example worked fine on 4.1.2. > > Where I can get it? Binaries currently are not available, but you can install it from development source tree: http://dev.mysql.com/doc/mysql/en/Installing_source_tree

Re: international LIKE in 4.1.1-alpha

> I was able to repeat it on 4.1.1 but your example worked fine on 4.1.2. Where I can get it? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: international LIKE in 4.1.1-alpha

"Juri Shimon" <[EMAIL PROTECTED]> wrote: > Hi! > Win2000, MySql 4.1.1-alpha, cp1251 > > select 'ÃÎÍ×ÀÐÀ' like '%ÃÎÍ×ÀÐÀ%'-> 1 > select 'ÎËÅÑß ÃÎÍ×ÀÐÀ' like '%ÃÎÍ×ÀÐÀ%'-> 0 > > > It's a pity 8( > > Hint : > select 'ÎËÅÑß ÃÎÍ×ÀÐÀ' like '%%ÃÎÍ×ÀÐÀ%'-> 1(change leading % to %%) >

international LIKE in 4.1.1-alpha

Hi! Win2000, MySql 4.1.1-alpha, cp1251 select 'ГОНЧАРА' like '%ГОНЧАРА%'-> 1 select 'ОЛЕСЯ ГОНЧАРА' like '%ГОНЧАРА%'-> 0 It's a pity 8( Hint : select 'ОЛЕСЯ ГОНЧАРА' like '%%ГОНЧАРА%'-> 1(change leading % to %%) Variables: character_set_system=utf8 character_set_server=cp1251

Using like in with nested selects

Hello, I have a problem. I have two tables one with the long sentences(TABLE 1) and one with the words in that sentences(TABLE 2). what i need to do is query the TABLE 2 by giving a part of the word ---WILD CARD MATCHING-and get the complete words which contains this part. Then Use thi

Hit on Reg.Expression like in Perl

Hi, I wonder if something like in perl is possible: data in rows: 1) a12345xb54321x 2) b54321xa12333x I want to extract b(number) and store into another table. In perl this would work with pattern matching (reg.expressions) like: $data =~ s/.*?b(.*?)x.*?/$1/; $data_b = $1; so

Re: Bug ?? combining NOT and like in where clause

"Tor-Erik Hagen" <[EMAIL PROTECTED]> Sent: Sunday, January 28, 2001 12:56 AM Subject: Bug ?? combining NOT and like in where clause > Tested on the following versions of mysql: 3.22.32, 3.23.31 on Linux > > Description: > "where not field like pattern" gives

Bug ?? combining NOT and like in where clause

Tested on the following versions of mysql: 3.22.32, 3.23.31 on Linux Description: "where not field like pattern" gives empty set, while "where field not like pattern" return what i expect How-To-Repeat: create table testtabell(test varchar(10)); insert into testtabell values('test.com')