Alexandre Busquets Triola
<[EMAIL PROTECTED]> wrote:
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?

Your query should work as shown. Do you have any problems with it?

Igor Tandetnik

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

Reply via email to