Posted by Da Dimmi de wit on 01/12/07 01:00

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

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

[Reply to this message]