Re: Problem

2004-05-03 Thread mickael
Sorry, it's an error - Original Message - From: mickael To: [EMAIL PROTECTED] Sent: Monday, May 03, 2004 4:07 PM Subject: Problem I have a problem with a character for example : in my databas i have a word like :" papier d'emballage" and if

Problem

2004-05-03 Thread mickael
I have a problem with a character for example : in my databas i have a word like :" papier d'emballage" and if i try this request : $requete = "SELECT * FROM `produit` WHERE MATCH (nom) AGAINST ('emballage*' IN BOOLEAN MODE);"; --->it doesnt't work, because of this character :" ' " and ther

Probleme avec "WHERE MATCH ... AGAINST"

2004-05-03 Thread mickael
Bonjour, je ne sais pas si vous allez pouvoir me répondre mais j'ai un problème avec le "FULL TEXT". Comment faire pour ke la fonction de recherche des mots ne prennent pas en compte l'appostrophe? "MySQL utilise un filtre très simple pour séparer le texte en mots. Un "mot" est n'importe quell

Re: Images in a table

2003-12-01 Thread Mickael Bailly
ent primary key, data LONGBLOB not null default ''); Hopa that helps On Saturday 29 November 2003 19:41, Zenzo wrote: > How can I insert images in a table if I can do it with MySQL? > > __ > Do you Yahoo!? > Free Pop-Up Blocker - Get it now >

loosing connection to server when creating a table!

2002-10-18 Thread Mickael Bailly
: ready for connections And in the directory '/var/lib/mysql/temp', there is a file 'oups.frm', but no 'oups.MYI' MySQL version is 3.23.52 handmade running on a RedHat 6.2 (linux 2.2.14) The server has no big load. Does someone know how to

Re: keeping given order in resulset

2002-03-22 Thread Mickael Bailly
Hello, the 'order by' clause just order my results by ascending value, but don't keep the order I gave in the 'IN(...)' clause.. So it doesn't solve my problem. Mickael On Friday 22 March 2002 12:08, Jayasimhan A wrote: > Try "order by id". >

Re: keeping given order in resulset

2002-03-22 Thread Mickael Bailly
Hello, there is no difference between select id, name from table where id in (5,3,7) and select id,name from table where find_in_set (id, "5,3,7"); Or I didn't see it... anyway this doesn't solve my problem. Mickael On Friday 22 March 2002 11:32, Georg Richter wrote: &g

keeping given order in resulset

2002-03-22 Thread Mickael Bailly
gave into the 'IN(...)' clause ? So I would have resultset like: | id | name | | 5 | 'foo' | | 3 | 'bar' | | 7 | 'foobar' | Thanks, Mickael - Before posting, p