Re: [PHP-DB] full text search

2005-08-11 Thread Joe Harman
http://dev.mysql.com/doc/mysql/en/fulltext-search.html also.. i just use a LIKE in you sql statement On 8/11/05, Yui Hiroaki <[EMAIL PROTECTED]> wrote: > > I have a question about full text search using mysql and php. > There is text or html file data inside mysql, then I would like > to searc

[PHP-DB] full text search

2005-08-11 Thread Yui Hiroaki
I have a question about full text search using mysql and php. There is text or html file data inside mysql, then I would like to search text from these file. when I filed some text inside text box in web site. mysql colum has below b_col_id, b_col, file_name I have wrote the code; ---head

[PHP-DB] Re: MySQL/PHP how to put the results of one query in another query

2005-08-11 Thread Basil Mohamed Gohar
Pedro Quaresma de Almeida wrote: Hi I have two MySQL databases, on for aeromodelistas (aeromodelling) and another for Códigos Postais (Postal Codes). I whant to do the following query SELECT CódigoPostal FROM Aeromodelistas WHERE CódigoPostal IN (SELECT distinct(CP4) FROM codigopostal.LOCAR