multiple MATCH condition

[Yunus Bookwala]

  
Hi

Is it possible to have multiple MATCH and WHERE conditions in a single SELECT 
query?

e.g.
SELECT * FROM books_info MATCH(books_name) AGAINST ('Mysql') OR 
MATCH(books_authors) AGAINST ('abc xyz') OR WHERE books_isbn LIKE "%8922b238h%"

The table structure is as below
--------------------------
CREATE TABLE IF NOT EXISTS `books_info` (
  `books_id` int(11) NOT NULL auto_increment,
  `books_name` varchar(200) NOT NULL,
  `books_authors` varchar(120) default NULL,
  `books_isbn` varchar(20) default NULL,
  `books_price` decimal(8,2) default NULL,
  `books_publisher_id` varchar(50) default NULL,
  `book_dateadded` datetime NOT NULL,
  PRIMARY KEY  (`books_id`),
  UNIQUE KEY `books_name` (`books_name`),
  FULLTEXT KEY `books_name_2` (`books_name`,`books_authors`),
  FULLTEXT KEY `books_authors` (`books_authors`),
  FULLTEXT KEY `books_name_3` (`books_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=642 ;
--------------------------

I am running Mysql 5.0.67.

Am I missing something?

Thanks
Yunus