Up Prev Next
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
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 ?