On 27.02.2001 14:11:51 Toth Dalibor wrote:
> I managed to make, a match throughout multiple fields but single table:
> SELECT rid,nazivRecepta,MATCH nazivRecepta,uvod,nacinPripreme AGAINST
> ('vegetine') as relevance FROM recepti order by relevance desc
>
> I also need to include nazivSastojka field from table sastojci into upper
> query.
> How do I do that?
SELECT rid,nazivRecepta,MATCH
sastojci.nazivSastojka,nazivRecepta,uvod,nacinPripreme AGAINST ('vegetine') as
relevance FROM recepti order by relevance desc
> And another question is how to insert date into database but in format
> dd.mm.yyyy.
Well, *WHY* would anyone want to do this?
*I* always use datetime columns and use date_format when retrieving the data
from the row.
Anyway, you could use a DATE column, which would store the date as '2001-02-21'
if you retrieve it in "raw" format. But again, even here you can use mysql's
date_format.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
