Search Result

mike809 · Aug 18 '11, 01:24 PM

I'd like to get address of certain links with desired text. Let's say I want to get links containing a word "BMW".

Code:

<a href="http://abc.com/xxxx">Dodge</a>
<a href="http://abc.com/a123.php">Used [B]BMW[/B] card</a>
<a href="http://xyz.com/ferrari">Brand new Ferraris</a>
<a href="http://xyz.com/vjklj"><img src="pic.jpg"

...

Franco Cassar · Feb 1 '11, 11:40 AM

Ok, so I need to make the PHP form detect whether a string starts with the substring "DonVito:" or not. However, it's always returning a false even when DonVito: is present.

Code:

<?php
$host="localhost"; // Host name
$username="****"; // Mysql username
$password="***"; // Mysql password
$db_name="*******"; // Database name
$tbl_name="post";

...

Rob S · Jan 5 '11, 05:32 PM

Hi,
I am not sure where I am going wrong with this code.
It seems to work fine for a small text file but when I use files larger than 100MB it does not give me an accurate count.
The program is pretty simple. It should return the number of occurences of a substring from within a text file. I look for a match to the first character of the substring and if found then my code should test to see if the whole substring exists. ...

ciqeane · Aug 19 '10, 03:57 AM

here is the sample data

Code:

CREATE TABLE Boo (
keycol INT PRIMARY KEY,
datacol VARCHAR(20));

INSERT INTO Boo VALUES(1, 'DM/B19S/7281520');
INSERT INTO Boo VALUES(2, 'NW/L11U/BALL 10/300');
INSERT INTO Boo VALUES(3, 'RK/H11S/65-2511RK');
INSERT INTO Boo VALUES(4, 'FI/G21U/0004/BN5-12');
INSERT INTO Boo VALUES(5, 'FN/199U/FABRICATE');

Here is my query, please help me figure out...

pnunbe · May 17 '10, 07:51 AM

Hi,

I have a problem with the 'substring' function of XPath in VB.NET (VS 2005).

My code looks like this:

Code:

  dim Dom As new XmlDocument
    Dim mgr As New XmlNamespaceManager(Dom.NameTable)
   'mgr.AddNamespace("fn", "http://www.w3.org/2005/xpath-functions/#substring")
   mgr.AddNamespace("fn", "http://www.w3.org/2005/xpath-functions")

...

adnankatmer · May 2 '10, 08:01 AM

Hello,

As much as I understand, MySql does not support indexes on substring selects. I have need a query like:

Code:

					SELECT 
						DISTINCT C.CODE, 
						C.NAME
					FROM 
						mtt_table1 A,
						mtt_table2 B,
						mtt_table3 C,
						mtt_table4 D
					WHERE 1
						AND (C.NAME LIKE '%abc%' OR C.KEYWORDS LIKE '%abc%')
						AND ( SUBSTRING(B.GTIP,1,4)

...

jkmyoung · Apr 14 '10, 02:50 PM

Hey, I'm trying to find an algorithm to approximately match different substrings within a master list, with some forgiveness on spelling.

Say you are allowed 3 errors in the string match:
Defining error: having to remove or add a character.
If you have to replace a character, that counts as 2 errors.
Also the search is case-insensitive for now.

So abcd and abc have 1 error
bcd and abcde...

Search Result

Extracting URL from a link containing a specific string

Why is the strpos function always returning a false?

Trying to find substring efficiently.

SQL case substring problem. please help

Problem with XPath 'substring' function

MySQL Substring Index Problem

String Matching with Mistakes