Sedang Disiapkan

Retrieve web links from .sql file

Hi recently had a website crash, had about 1,000 links on it. Have the latest .sql file that i would like the info retrieved from. I could do this manually but it will likely take a long time that i would prefer to avoid. However it can be retrieved is fine with me. I also had these in categories, not sure if these can be retrieved by category would be even better.

Here is a sample of the text followed by what i am looking for.... Category was immigrations.

INSERT INTO `jos_eweblinks` VALUES(106, 55, 0, 'New immigration bill puts local police on front line of border battle', 'new-immigration-bill-puts-local-police-on-front-line-of-border-battle', '[login to view URL]', '', '2011-06-10 07:57:59', 3, 1, 0, '0000-00-00 00:00:00', 23, 0, 1, 'show_image=1\ntarget=1\n\n', '');

I want the headline and the link.

'New immigration bill puts local police on front line of border battle',

'[login to view URL]',

Another one

INSERT INTO `jos_eweblinks` VALUES(107, 55, 0, 'Arizona passes tough illegal immigration law', 'arizona-passes-tough-illegal-immigration-law', '[login to view URL]', '', '2011-06-10 07:58:17', 4, 1, 0, '0000-00-00 00:00:00', 24, 0, 1, 'show_image=1\ntarget=1\n\n', '');

INSERT INTO `jos_eweblinks` VALUES(108, 55, 0, 'Arizona Sheriff Says Cops Are Being Killed by Illegal Aliens; Joins Call for U.S. Troops at Border', 'arizona-sheriff-says-cops-are-being-killed-by-illegal-aliens-joins-call-for-us-troops-at-border', '[login to view URL]', '', '2011-06-10 07:58:40', 5, 1, 0, '0000-00-00 00:00:00', 25, 0, 1, 'show_image=1\ntarget=1\n\n', '');

'Arizona passes tough illegal immigration law',

'[login to view URL]

Kemahiran: MySQL, Perl, SQL

Lihat lagi: border html 5, link sql file html, Sql 2012, reuters, retrieve, police, immigration website, arizona, looking sql, sample perl, link sql, perl sample, aliens website, killed, insert sql, text sql, text html perl, joins, local file, 107

Tentang Majikan:
( 46 ulasan ) edwardsville, United States

ID Projek: #1488783