If i try to search which is better in search box its not giving result any idea..(i tryied in back end also its not giving crt result)
code:SELECT * FROM `xxx_objects_entity`where MATCH (`title`) AGAINST ("which is better" IN BOOLEAN MODE )
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by Raül Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
- Brett@brett.profitt

Brett - 0 likes
- Sharon@sharon

Sharon - 0 likes
- DhrupDeScoop@Dhrup2000

DhrupDeScoop - 0 likes
- Sharon@sharon

Sharon - 0 likes
- DhrupDeScoop@Dhrup2000

DhrupDeScoop - 0 likes
Showing rows 0 - 0 ( 1 total, Query took 0.1248 sec)
"Lorem ipsum" IN BOOLEAN
guid title description
520
Lorem ipsum dolor
Lorem ipsum dolor sit amet, consectetur adipiscing...
- Sharon@sharon

Sharon - 0 likes
- DhrupDeScoop@Dhrup2000

DhrupDeScoop - 0 likes

guid title description
Edit
Inline Edit
Copy
Delete
518
which better
test img 1
Edit
Inline Edit
Copy
Delete
520
which is better
dont know

guid title description
Edit
Inline Edit
Copy
Delete
518
which better
test img 1
Edit
Inline Edit
Copy
Delete
520
which is better
dont know
You must log in to post replies.MySQL's text search leaves a lot to be desired. What is the title you know exists that you expect back?
Berrt can you create one tittle "Which is better" and search that with mysql aganist it give empty result.
MATCH (`title`) ? `title` is not a field on entity table ! ;-) but try same sql on objects_entity - it will woiky oki
Drup read completly and give reply :) (check my code)
lolz ;-P while you're telling me to read completely -
that sql query works completely here ;-P
..(i soo.... mys-typed ;-) ? but you missed the part that sez " will woiky " ;-X
code woiky completely for me here to give a correct result and
i kinda do see 'lorem ipsuym; coming back !-X ;oO
so... your code that does not woiky for you => does woiky for me !
what else is there to say ?? so - which is better ?
code that works or code that gives an empty result ?
but the sql query is the same ??? QED...
`title`SELECT *
FROM `iconmatrix_objects_entity`
WHERE MATCH (
) AGAINST (
Drup insted of "which is better" you give any other thing it will work but its not searching "which is better"
is that phrase "which is better' so important for your whole application ? boolean also is affected by what it calls relevance (which trips of into some nether-worlds) -- so - either your index did not create or relevance is unreliable.