OK, here's possibly a weird one. Is there any way to do string comparisons
and ignore all non-alphanumeric characters? For instance, check "foobar" and
have it match an existing record of "f$#!oo B(a)*R".
- Daniel 3 3641
"steve" <Us************ @dbForumz.com> wrote in message
news:41******** **@news.athenan ews.com... "Daniel Tonks" wrote: > OK, here’s possibly a weird one. Is there any way to do string > comparisons > and ignore all non-alphanumeric characters? For instance, check > "foobar" and > have it match an existing record of "f$#!oo B(a)*R". > > - Daniel
check for "mysql regex" on search engines. http://dev.mysql.com/doc/mysql/en/Regexp.html
I looked into that, but it only seems useful to specific pattern matching -
I can't find any way to selectively NOT match something that is unknown,
while continuing to match something else (and not have it also match normal
characters, such as "footbar"). After some Googling I found someone who
merely wanted to ignore spaces, but alas it looks like even that cannot be
done with mere database commands.
So I many have to go the inefficient route: retrieve the entire column and
do my own processing.
- Danniel
"Daniel Tonks" <dtonks@sunstor mADD-DOT-COM> skrev i en meddelelse
news:41******** **************@ authen.newsread er.visi.com... "steve" <Us************ @dbForumz.com> wrote in message news:41******** **@news.athenan ews.com... "Daniel Tonks" wrote: > OK, here's possibly a weird one. Is there any way to do string > comparisons > and ignore all non-alphanumeric characters? For instance, check > "foobar" and > have it match an existing record of "f$#!oo B(a)*R". > > - Daniel
check for "mysql regex" on search engines. http://dev.mysql.com/doc/mysql/en/Regexp.html So I may have to go the inefficient route: retrieve the entire column and do my own processing.
If you do this search often, make an extra column and store the "cleaned"
version of the column.
Leif This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Douglas F. |
last post by:
I have a download.php that handles some form posts from a html page. It
attempts to use Header(Location: ......) to download a file. It works when
out of ssl, but when under ssl, I get the 'Headers already sent' error. The
ob_start() and ob_end_flush() calls are being ignored. I theorize that the
Host's SSL package has to allow buffering, or maybe it is the Server?
any suggestions or resolutions will certainly be appreciated on this.
|
by: Robert Downes |
last post by:
I'm using the following in a page that I'm testing in Mozilla:
p.actionLinkBlock {border: 1px #000000 dashed; padding: 0.2cm; width: auto}
But the dashed border is extending to the right-edge of the screen. I
want it to only extend as far as it needs to to nicely contain the
content within (a couple of links).
Is width: auto the wrong property to do this? Is Mozilla rendering the
style wrong?
|
by: Paul Bramscher |
last post by:
What are the mechanisms to make words like a/an/the in text and varchar
character fields ignored when performing SELECT and utilizing ORDER BY
in SQL queries?
I've done some hunting around into documentation on character sets (but
they are geared mainly at character-by-character rules) and saw some
reference to string collating and stop words -- but not seen any of this
all put together.
Thanks for any assistance,
|
by: lac |
last post by:
Hello all,
I am trying to make horizontal bars of different lengths. I tought
either SPAN or DIV would work but it only works for IE. I have a small
example at: http://sedivy.com/test.htm
Let me know if I missed something.
Thanks,
Lac
|
by: Vladi |
last post by:
Experience is highly requested.
I can't find solution for the following problem:
I am making VBA code for moving/modifying data from "old" tables into
"new" ones. In fact, this is part of the upgrade module for a data entry
product. In the existing tables at customers' site there could be some
values in some fields, which violate validation rules. I have to copy
them as they are, in the new tables, in the fields having the same...
| |
by: Srikanth |
last post by:
Hi
Can any one say how to check a hashtable by ignoring the case of key
supplied. I want the following requirement
It should not allow the user to do the following
Hashtable table = new Hashtable();
a) table.Add("one",1);
b) table.Add("One",1);
|
by: CJ Taylor |
last post by:
Another quesiton,
I have a form, with a control on it that has a handler for control.validated
event.
Now, if that control has focus, and I click the close button the validation
event fires..
So I think to myself, how to tell this, so I add a private property on the
form called IsClosing, which is set by the Form.Closing event...
|
by: Daniel Gaudreault |
last post by:
One of our developers came across the fact that postgres is ignoring
spaces when sorting results from a query. We are using PGSQL 7.3.4 on
the backend. Is there something that needs to be set somewhere to for
the sort to not ignore spaces?
Thanks,
Dan
|
by: BACON |
last post by:
I'm just starting the process of reorganising my modest little website
and cleaning up all the HTML, and the logical place to begin was with
the homepage. I made a simple little ASP.NET control that I can drop
into the beginning of any page and it will generate HTML to display my
logo, a link, and (optionally) a quote of the day, all of which will be
horizontally centered at the top of the page by my default stylesheet.
For the main page,...
|
by: mrafi |
last post by:
Hey All,
I am working with numpy
I have a data set with a lot of nan values, and i want to calculate standard
deviation
is there a direct function to do it for example nansum(or something like
this),
to calculate standard deviation ignoring nan values??
Thanks
Rafi
--
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |