database - Like Command not working Oracle SQL -

i new databases , php. in code trying create table within php script, here have.

create table booktable(bookid int primary key,                    bookname varchar(100),                    published date,                    price number(18,2),                    author1 varchar2(30),                    author2 varchar2(30));  insert booktable (bookid, bookname, published, price, author1, author2) values (1, 'fundamentals of digital logic vhdl design','14-apr-08', 190.25,'stephen brown','zvon ko g.vranesic'); insert booktable (bookid, bookname, published, price, author1, author2) values (2, 'distributed systems principles , paradigm','26-jul-13', 197.80,'andrew s. tanenbaum','maarten van steen'); insert booktable (bookid, bookname, published, price, author1, author2) values (3, 'eat real food solution permanent weight loss , disease prevention','1-apr-15', 29.99,'david gillespie',''); insert booktable (bookid, bookname, published, price, author1, author2) values (4, 'introduction computational science modeling , simulation sciences','2-may-06', 132.75,'angela b.shiflet','george w. shiflet'); insert booktable (bookid, bookname, published, price, author1, author2) values (5, 'live on less practical guide running lean household','27-may-15', 19.00,'jody allen',''); insert booktable (bookid, bookname, published, price, author1, author2) values (6, 'middle school: rotten luck','1-jul-15', 15.99,'james patterson',''); insert booktable (bookid, bookname, published, price, author1, author2) values (7, 'clementine rose , birthday emergency','1-jul-15', 12.99,'jacqueline harvey',''); insert booktable (bookid, bookname, published, price, author1, author2) values (8, 'my life it''s long story','26-may-15', 32.99,'willie nelson',''); insert booktable (bookid, bookname, published, price, author1, author2) values (9, 'sword of summer magnus chase','7-oct-15', 15.99,'rick riordan',''); 

the table created successfully, when try run query

`sql> select *        booktable       bookname '%my%';` 

it says no rows selected. can't figure out doing wrong. thanks.

@alfasin right. lower achieve trying do

select * booktable lower(bookname) '%my%';