SEO

#1 (**permalink**) 02-28-2008, 10:28 AM

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

#2 (**permalink**) 02-28-2008, 10:28 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

using fulltext like 'like'