what is the best SQL editor
that support local languages such as
ARABIC

just about any text editor works fine for editing SQL. i like jEdit for any playing with text. Or jEdit X.

I like the look of jedit - unlike excel it does recognise the data format.

But how do I get in to lines of data to edit. I have 3000 links waiting for validation (this is one of my complaints about XOOPS you can't activate a load of links as once by ticking boxes for example).

this is an example of the data:-
INSERT INTO `xoops_mylinks_links` VALUES (3067, 30, 'Browser Hijack Recover(BHR)', 'http://www.browser-hijack.com', '', '', 2369, 0, 1103090123, 0, 0.0000, 0, 0);
INSERT INTO `xoops_mylinks_links` VALUES (3068, 1, 'Source Code Browser', 'http://www.rebrandsoftware.com/showsoftware2.asp?soft_id=7', '', '', 2656, 0, 1103110638, 0, 0.0000, 0, 0);
INSERT INTO `xoops_mylinks_links` VALUES (3069, 5, 'Time Meter for MS Outlook', 'http://www.timemeter.com/index.shtml', '', '', 1541, 0, 1103116954, 0, 0.0000, 0, 0);
INSERT INTO `xoops_mylinks_links` VALUES (3070, 5, 'Time Meter for MS Outlook', 'http://www.timemeter.com/index.shtml', '', '', 1541, 0, 1103116954, 0, 0.0000, 0, 0);

I need to get in an change the 0 to a 1 to activate over 3,000 links is there a way?

The zero i need to change is ['', '', 1541, 0,] last one.

Any ideas maybe a macro?

thanks

Andrew

Might be easier to add them all to your db, then use SQL to change that field.

If your host supports it, try PHPMyAdmin
http://www.phpmyadmin.net/

You just need to run an SQL query on the links table.

e.g.

ok yes i have phpmyadmin access

(although I have next to no knowledge of it or sql queries).

would i type exactly
Quote:
to achieve what i want?

Do I need to specificy like find '0' replace with '1'?

thanks

Andrew