问SQL查询，我是不是遗漏了什么？

EN

SELECT * FROM table1 WHERE NAME= 'Bob' OR NAME= 'John';

SELECT * FROM table1 WHERE NAME= 'Bob' OR NAME= 'John';

DATA                NAME    MESSAGE                         TIMEZONE
01/03/2014 10:27    Bob     What time do you want to meet?  London
18/02/2014 02:43    John    What time is it in London?      New york
14/02/2014 00:50    Bob     Meeting today?                  London

SELECT name,message 
FROM table1
WHERE ROUND ((CHAR_LENGTH(message)
            - CHAR_LENGTH( REPLACE ( message, "out", "") ) 
            )/CHAR_LENGTH("out")) =1

SELECT * FROM table1 WHERE NAME IN ('Bob', 'John');