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