| Autor | Zpráva | ||
|---|---|---|---|
| unlucky Profil |
#1 · Zasláno: 10. 6. 2011, 20:31:13
mám dotaz:
select a.*,u.id as uid,u.user as autor, a.id as idik,count(k.id) as nr_comments, DATE_FORMAT(`added`, '%Y' ) AS rok,
DATE_FORMAT(`added`, '%e' ) AS den, DATE_FORMAT(`added`, '%M' ) AS mesic,
MATCH(a.title, a.content)
AGAINST ('Rakousko') AS score
from articles a left join users u on u.id=a.author
left join comments k on a.id=k.article_id
WHERE MATCH(a.title, a.content)
AGAINST ('Rakousko') and a.active=1
ORDER BY score DESCNajde to ale pouze v title, nikoli v content. Sloupce mají fulltext |
||
| unlucky Profil |
#2 · Zasláno: 10. 6. 2011, 23:36:28
teďka jsem tam přidal in boolean mode a hledá to ve 2 sloupcích, ale vrací to pouze jenom 1 výsledek, přitom by tam mělo být více
select a.*,u.id as uid,u.user as autor, a.id as idik,count(k.id) as nr_comments, DATE_FORMAT(`added`, '%Y' ) AS rok,
DATE_FORMAT(`added`, '%e' ) AS den, DATE_FORMAT(`added`, '%M' ) AS mesic,
MATCH(a.title, a.content)
AGAINST ('rakousko' IN BOOLEAN MODE) AS score
from articles a left join users u on u.id=a.author
left join comments k on a.id=k.article_id
WHERE MATCH(a.title, a.content)
AGAINST ('rakousko' IN BOOLEAN MODE) and a.active=1
group BY score DESC |
||
|
Časová prodleva: 13 let
|
|||
0