searching 2 db fields

[bellmd]

I'm trying to search two fields in a database. The SQL statement below returns all the records in the database:

select * from table where (desc OR title LIKE "%this%") AND (desc OR title LIKE "%that%")

 

[Mighty]

bellmd,

Is that syntax definitely vaid?

Does it work if you change it to the following:

select * from table where (desc LIKE '%this%' OR title LIKE '%this%') AND (desc LIKE '%that%' OR title LIKE '%that%')
Mise Le Meas,

Mighty

 

[bellmd]

Yes, the syntax is correct. That is what I am currently using, and it works well. The main problem is that not all the records have a description, because some have sufficient information in the title, and without serching the titles also some of the record will not show up in through the search.

 

[Swany]

What SQL database are you using..

desc OR title LIKE "%that%" isn't valid ANSI sql

you should do as Mighty suggested and use the correct SQL syntax..

I think the reason your query is returning all records because it is looking at (desc OR title LIKE "%that%&quot to mean ([DESC IS NOT EMPTY] OR TITLE LIKE "%that%&quot