PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

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
%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