multiple queries

[_giles_]

Hi

 

I'm working on a query where I'd like to be able to search one OR two attributes. I've come accross a few postings that lead me to the code below. It works fine if I put something in both attributes but fails if I leave the second blanc. Can you help? 

 

SELECT * FROM books

WHERE title LIKE '%$title%'

AND title_sub LIKE '%$title_sub%'

ORDER_BY print_id

 

(I would ideally like to make the first attribute optional. I may also want to add a few more attributes later)

 

[fenway]

This generally has to be done at the application level, where you build your where clause .. but in this case, it should evaluate to %% if blank, which although slow, shouldn't "fail".