mohansinfh — 2011-04-03T02:20:42-04:00 — #1
I don't know query for this custom selection from mysql.
My question is similar to the thing as in PHP, we have a function isset($variable) and !empty($variable), is there anything similar in mysql? because I want to fetch a set of records, where book_id is set or not left empty.
spacephoenix — 2011-04-03T02:40:50-04:00 — #2
Can you post the output of a SHOW CREATE TABLE for the tables involved?
What fields (and from which tables) are required in the result set (please post an example of a result row that you expect to be returned by MySQL)?
mohansinfh — 2011-04-03T02:47:47-04:00 — #3
This is the example structure. I want to fetch from table2, where book_id exists.
r937 — 2011-04-03T03:58:17-04:00 — #4
WHERE book_id IS NOT NULL
mohansinfh — 2011-04-04T23:24:22-04:00 — #5