ft_min_word_len=3
stopwords! IDIOT! I was testing using stop words! :)
let me change my test org name.
thanks
> FULLTEXT (at least the MyISAM version) has 3 gotchas:
> ft_min_word_len=4, stopwords, and the 50% rule
>
>> -Original Message-
>> From: shawn green [mailto:shawn.l.gr...@oracle
Actually, looks like I'm wrong.
For testing purpose I made an org
"Comp&Me"
When search for "Comp" it's gonna
be shown on the list.
When search for "Comp&" it's also gonna be shown. But
"Construction Company" as well.
Then I changed the name of
the test org to "Com&Me".
Searching for "Com", th
Another correction: Searching for "Com", the test org is NOT
gonna be listed but all others will.
Searching for "Com&" no results at all.
�
�
>
> Actually, looks like I'm wrong.
> For testing purpose I made an org
> "Comp&Me"
> When search for "Comp" it's gonna
> be shown on the list.
Hi to all,
I have this full text search query
SELECT name, org_id,
address_id
FROM organization
WHERE org_active='Y' AND MATCH(name) AGAINST('AB&C*' IN BOOLEAN
MODE)
and I'm not getting any results. And there IS a org AB&C,
Inc.
My assumption is the ampersand sign as a part of the
no other item_ids. This is obvisouly not what you want.
Geert-Jan
Correct. That's why I use "select distinct org_id, item_id" in sub-
query.
Is here anybody from mysql development team, to suggest to build IN
ALL function?
:-)
2011/3/17 LAMP
First I was thinking ther
> What I need is a list of orgs they bought all of items 34, 36, 58,
63. every of them.
Some solutions under "What else did buyers of X buy" at http://www.artfulsoftware.com/infotree/queries.php
.
PB
---
On 3/17/2011 12:00 PM, LAMP wrote:
Yes, that was my question. Though, si
y
description of you want only wastes both your time and mine.
As I stated earlier, English is not my first language and I was trying
to do my best. Sorry for confusing you.
--
Rhino
On 2011-03-15 20:35, LAMP wrote:
On Mar 15, 2011, at 6:18 PM, Rhino wrote:
All you should need is thi
of
MySQL installed so I can't try this myself to be sure it works in
your version of MySQL.
--
Rhino
your query will give me every org_id that has ANY of item_id., I need
org_id that has ALL of item_id. right?
result would be
2607
1520
8934
7295
1649
8871
On 2011-03-15 18:51, LAMP wro
is better solution?
Thanks for any help.
LAMP
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
is this:
mysql blah blah blah < the_select_query.sql > the_output_i_want.txt
That gives you a tab-delimited text file with column headings.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.
Eric Bergen wrote:
select into outfile is the correct way. What do you mean by doesn't
work? Does it give you an error?
It was an issue with permissions :-)
Thanks
On Sat, Jan 8, 2011 at 3:04 PM, LAMP wrote:
Hi guys,
I wonder how to store to csv or txt file result from SELECT
Hi guys,
I wonder how to store to csv or txt file result from SELECT query?
not a whole table nor database. Just results from SELECT query.
Usually I use MySQL Query Browser and Export feature, but in this
case I don't have access with MySQL Query Browser. Though, I have a
command line acces
From: Andy Shellam
To: Lamp Lists
Cc: mysql@lists.mysql.com
Sent: Wednesday, December 17, 2008 2:48:31 PM
Subject: Re: need help with query...
Hi,
>
> Hi Andy,
> the reason I can't use this because fields (columns) in select statement
&
From: Andy Shellam
To: Lamp Lists
Cc: mysql@lists.mysql.com
Sent: Wednesday, December 17, 2008 2:29:08 PM
Subject: Re: need help with query...
Hi Afan
Why not prefix your field names with the table name?
select
p.first_name AS person_first_name
.
not exactly this way but something like this:
$data = array(
'people' => array('lamp', 'lists', 1, '2008-12-12'),
'organization' => array(56, 'Lamp List', 'web'),
'addresses' => array('123 Main St.', 'Toon Town', 'NY', '12345')
}
thanks for any help.
-afan
- Original Message
From: John Hicks <[EMAIL PROTECTED]>
To: Lamp Lists <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Tuesday, July 8, 2008 11:20:16 AM
Subject: Re: which query solution is better?
Lamp Lists wrote:
> hi,
> I would like to get your opinions reg
hi,
I would like to get your opinions regarding which query you think is better
solution and, of course - why.
I have (very simplified example) 3 tables: orders, members and addresses
I need to show order info for specific order_id,
solution 1:
select ordered_by, order_date, payment_method, order
Thanks.
Though, I added, repair table, restarted mysql - and
the same
:(
-ll
--- Warren Young <[EMAIL PROTECTED]> wrote:
> Lamp Lists wrote:
> > I need to change ft_min_word_len fro 4 to 3. the
> > proces is very well explained on mysql.com
> > though, when open
hi,
I need to change ft_min_word_len fro 4 to 3. the
proces is very well explained on mysql.com
though, when open /etc/my.conf can't find the
ft_min_word_len line?
when check is there:
mysql> show variables like 'ft_min_word_len'
ft_min_word_len4
am I looking at the wrong file or something?
--- Lamp Lists <[EMAIL PROTECTED]> wrote:
>
> --- Lamp Lists <[EMAIL PROTECTED]> wrote:
>
> > hi,
> > I created table "tasks"
> > create table tasks(
> > task_id, int(4) not null primary key,
> > task text not null,
> > res
--- Lamp Lists <[EMAIL PROTECTED]> wrote:
> hi,
> I created table "tasks"
> create table tasks(
> task_id, int(4) not null primary key,
> task text not null,
> resolution text not null,
> fulltext (task, resolution)
> )engine=myisam
>
>
hi,
I created table "tasks"
create table tasks(
task_id, int(4) not null primary key,
task text not null,
resolution text not null,
fulltext (task, resolution)
)engine=myisam
when I run
seect * from tasks match(task,resolution)
against('"certain service"' in boolean mode)
I would get one reco
hi,
I have table, something like:
create table example (
ex_id integer(8) not null auto_increment primary key,
ex_col1 int(8) null,
ex_col2 int(4) not null,
index(ex_col1),
index(ex_col2)
)engine=myisam;
ex_col1 and ex_col2 are indexed separately.
23 matches
Mail list logo
