I don't know if I understand your question, but you may want to
SELECT * FROM table
WHERE fieldname LIKE '%searchterm%'
Also, search at mysql.com for FULLTEXT in
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
and learn what you can do with this and when this will be good.
Sie schrieben am Mittwoch, 11. Juli 2001, 19:04:42:
> Hi List,
> Can anyone tell me how do i create a search engine
> query.?
> I am new to Mysql and know how to use a simple
> select * from "" where "" = "";
> but what about if I need to
> create a query for a search engine that looks for Every word.
> Thanks in Advance
> Pradeep Dsouza
> (Aspbyte Creations)
>
>------------------------------------------------------------------------------------------------------------------------
> This Email was sent by Pradeep Dsouza.
>
>------------------------------------------------------------------------------------------------------------------------
> Mail Me at : [EMAIL PROTECTED]
> : [EMAIL PROTECTED]
> Telephone : -091 - 022 - 7573097
> Address :
> RH-04 E-11 Sector -09
> CBD Navi Mumbai
> Maharashtra India.
> Visit Aspbyte Online at :
> Website:www.aspbytecreations.com
> Re:
> If you recieved this mail in Error please bounce the mail.
>
>------------------------------------------------------------------------------------------------------------------------
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
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
