Posted by Paul Lautman on 01/12/07 15:15

Da Dimmi de wit wrote:
> I have a database table that I need to query specific keywords from.
> I would like to do so using a + or -.
>
> Example:
>
> I have a table of :
> Dates Titles
> 1/1/07 The Bird Has Crashed Hard
> 1/5/07 Zalman IS Hot but Liquid N is Colder
>
> and I want to search on keywords in the Title.
>
> I understand I can use a:
> select * from Titles where Titles like '%Bird%'
>
> but would like to use a + / - . Is this possible in a SQL query, or is
> PHP required (using PHP code is not an issue if required)?
>
> Also any info on the speed of such a keyword query for 200K+ records
> or any special table attributes that would be required.
>
> TIA
> -DDW

Look at the FULLTEXT facilities

• Next in forum: Re: How do I select data from MySQL using a + or - qualifier ?
• Prev in forum: Re: php/mysql/apache installation on win98
• Thread view: Re: How do I select data from MySQL using a + or - qualifier ?

[Reply to this message]