Thanks a lot!!
On Wed, 10 Dec 2008 John Daisley wrote :
>Try
>
>SELECT * FROM books_info WHERE MATCH(books_name) AGAINST ('Mysql') OR
>MATCH(books_authors) AGAINST ('abc xyz') OR books_isbn LIKE "%8922b238h
>%"
>
>That should bring back any books with either 'Mysql' in the
>'books_name', 'abc xyz
Try
SELECT * FROM books_info WHERE MATCH(books_name) AGAINST ('Mysql') OR
MATCH(books_authors) AGAINST ('abc xyz') OR books_isbn LIKE "%8922b238h
%"
That should bring back any books with either 'Mysql' in the
'books_name', 'abc xyz' in the 'books_authors' or where the 'books_isbn'
matches the spe
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
--
