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?

--
http://josh.pixael.com

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.