Afficher un message
Vieux 24/09/2007, 22h34   #2
Paul Lautman
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: using fulltext like 'like'

j0sh wrote:
> hi all
> is possible to have with a fulltext row the result provided by
>
> "select * from table where title like 'key%'"?
>
> i tried with
>
> "select * from table where match (title) against ('key*' IN BOOLEAN
> MODE)"
> but result contain for example:
>
> - KEYword
> but also
> - give me a KEYword
>
> how can i select results like the first?


There is no point. If you want rows where a field begins with a partcular
string, use LIKE on the field itself.


  Réponse avec citation
 
Page generated in 0,08154 seconds with 9 queries