In a Perl script I'm running I need to query against a field that is a
string, but I only want to use a substring as the query condition.
This is an example of the string that I'm searching against:
Classic Perm, Curly Hair, Medical, Medium to Short, Monofilament Top,
Short Length, Synthetic Hair, Wavy Hair,
I want to use this substring as the condition: "Short Length".
I want to avoid the other occurance of "Short" as in "Medium to
Short".
There are thousands of strings like this so I have to make the query
generic.
Is this possible?
Thank you,
- D 2 1679
select * from tablename where stringfield like '%Short Length%' should work.
dp In a Perl script I'm running I need to query against a field that is a string, but I only want to use a substring as the query condition.
This is an example of the string that I'm searching against:
Classic Perm, Curly Hair, Medical, Medium to Short, Monofilament Top, Short Length, Synthetic Hair, Wavy Hair,
I want to use this substring as the condition: "Short Length". I want to avoid the other occurance of "Short" as in "Medium to Short".
There are thousands of strings like this so I have to make the query generic.
Is this possible?
Thank you,
- D
select * from tablename where stringfield like '%Short Length%' should work.
dp In a Perl script I'm running I need to query against a field that is a string, but I only want to use a substring as the query condition.
This is an example of the string that I'm searching against:
Classic Perm, Curly Hair, Medical, Medium to Short, Monofilament Top, Short Length, Synthetic Hair, Wavy Hair,
I want to use this substring as the condition: "Short Length". I want to avoid the other occurance of "Short" as in "Medium to Short".
There are thousands of strings like this so I have to make the query generic.
Is this possible?
Thank you,
- D This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Anand Pillai |
last post by:
To search a word in a group of words, say a paragraph or a web page,
would a string search or a regexp search be faster?
The string search would of course be,
if str.find(substr) != -1:...
|
by: Magnus Lie Hetland |
last post by:
I'm working on a project (Atox) where I need to match quite a few
regular expressions (several hundred) in reasonably large text files.
I've found that this can easily get rather slow. (There are...
|
by: Lukas Holcik |
last post by:
Hi everyone!
How can I simply search text for regexps (lets say <a
href="(.*?)">(.*?)</a>) and save all URLs(1) and link contents(2) in a
dictionary { name : URL}? In a single pass if it could....
|
by: Jon Maz |
last post by:
Hi All,
I want to strip the accents off characters in a string so that, for example,
the (Spanish) word "práctico" comes out as "practico" - but ignoring case,
so that "PRÁCTICO" comes out as...
|
by: Dmitry Korolyov |
last post by:
ASP.NET app using c# and framework version 1.1.4322.573 on a IIS 6.0 web server.
A single-line asp:textbox control and regexp validator attached to it.
^\d+$ expression does match an empty...
|
by: jiing24 |
last post by:
I try to use regexp to replace some html tags in DOM, but the result
seems some problems,
================================
<Script language="javascript" type="text/javascript">
var config =...
|
by: Uldis Bojars |
last post by:
Hi All,
I have encountered problems with JS RegExp.exec() and can't find what
is the problem. Could you help me?
formRequest is a function that extracts some information from
XMLHTTPRequest...
|
by: Nathan Sokalski |
last post by:
I have the following script that I am using to test some JavaScript RegExp
code:
function RE()
{
var testing1=new RegExp("*");
var testing2=new RegExp("{0,}");
var testing3=new RegExp("+");...
|
by: Matt |
last post by:
Hello all,
I have just discovered (the long way) that using a RegExp object with
the 'global' flag set produces inconsistent results when its test()
method is executed. I realize that 'global'...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |