Re: need help with query...

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 &

Re: need help with query...

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

need help with query...

. 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

Re: which query solution is better?

- 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

which query solution is better?

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

Re: can't find ft-min_word_len in /etc/my.conf ?

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

can't find ft-min_word_len in /etc/my.conf ?

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?

Re: different results between FULLTEXT search and LIKE search

--- 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

Re: different results between FULLTEXT search and LIKE search

--- 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 > >

different results between FULLTEXT search and LIKE search

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

how to re-index a table?

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.