[sqlite] select help

[Alexandre Busquets Triola]

Hi have this table

CREATE TABLE [blocklists] (
[blockval] VARCHAR(255)  NOT NULL
)

insert into blocklists blockval values('%lex%');

and I need do something like this

select count(*) from blocklists where 'alexandre' like blockval

How i can do something like with sqlite?


That i need is something how in string

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------