sybperl-l Archive

From: Oliver Scheit <oscheit at quoka dot com>
Subject: searching through text field
Date: Jun 10 1999 12:36PM

Sorry to bother you, but I've got this stupid problem:

I want to search through a text field in a table using the "like
%somestring%" method.
I read about the "readtext"-sql-statement, but I don't understand it.

Here's what I want to do: (using Sybperl::CTLib)

$query = $q->ct_sql( " select * from mytable where textcol like
'%searchstring%' " ) ;

now, "textcol" is of the type text.
How do I have to change my code so it'll work ?

Regards, Oli