On Mon, 08 Dec 2003 19:07:43 +0000, zzapper <[EMAIL PROTECTED]> wrote:
>Hi Ya, >I have a typical select as follows > > SELECT * FROM ytbl_development AS t1 > WHERE (t1.txtDevName LIKE '%#form.searchtext#%') >B) >Now I can filter any quotes from form.searchtext easy enough, but how >do I filter them the Left Hand Side eg from txtDevName?) > Is there no mysql solution to this? Most Where clauses are thus WHERE LHS Like/= RHS Now MySQL provides lots of operators for the RHS eg WHERE LHS RLIKE RHS But what I want to do is preprocess/filter the LHS before doing the comparison, I can find no information on this. In the past I have cheated by creating an additional column in my database eg txtDevNameClean which has all non-alphanumerics removed. am I barking up the wrong tree?? zzapper -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]