I tried to select tp-products table and find all keywords begin with b, then count the total number,but I failed when using the following SQL sentence,can anybody help with it.

select count(tp.id) as total select tp.`id`,tp.`keywords`from tp_products tp where LEFT(tp.`keywords`,1) LIKE 'b'

BTW, can somebody help to explain the usage of splitPageResults

Any comment and advice will be appreciated

John