Public Forums 71,145 posts

[nooran Developer nooranJoin date: June 2013Posts: 119Downloads:8Uploads:21 Thanks: 32 Thanked: 6 times in 1 posts]

#197608

Hello,

I don’t know if here is the right place to ask this quotation, but I feel someone could know the right answer.

I’m using ja TelineII template.
Actually, there are more than 80,000 rows in my #_assets table, but I don’t want to delete all of them, I only need to delete the contents that have column name for example “com_content.article.24203”

How is it to do that by using SQL query/queries ?
Is that possible?

Many thanks for your great help and support.

Best Regards
Raffet Ali

[pavit Moderator pavitJoin date: September 2007Posts: 15749Downloads:199Uploads:2274 Thanks: 417 Thanked: 4028 times in 3778 posts]

#534475

Hi

Use this syntax

DELETE FROM `#_assets` WHERE `name` = “com_content.article.24203”

[nooran Developer nooranJoin date: June 2013Posts: 119Downloads:8Uploads:21 Thanks: 32 Thanked: 6 times in 1 posts]

#534496

Thanks @pavit

But what if I need to delete a range from “com_content.article.2” to “com_content.article.24203” ?

[pavit Moderator pavitJoin date: September 2007Posts: 15749Downloads:199Uploads:2274 Thanks: 417 Thanked: 4028 times in 3778 posts]

#534503

<em>@nooran 426436 wrote:</em><blockquote>Thanks @pavit

But what if I need to delete a range from “com_content.article.2” to “com_content.article.24203” ?</blockquote>

Hi

DELETE FROM `#_assets` WHERE `name` BETWEEN “com_content.article.2” AND “com_content.article.24203”

[nooran Developer nooranJoin date: June 2013Posts: 119Downloads:8Uploads:21 Thanks: 32 Thanked: 6 times in 1 posts]

#534510

Hello pavit

It worked… but most of the times it gives this:
1 row deleted. ( Query took 0.0024 sec )

[pavit Moderator pavitJoin date: September 2007Posts: 15749Downloads:199Uploads:2274 Thanks: 417 Thanked: 4028 times in 3778 posts]

#534513

<em>@nooran 426456 wrote:</em><blockquote>Hello pavit

It worked… but most of the times it gives this:
1 row deleted. ( Query took 0.0024 sec )</blockquote>

You should do it with ID column and fix a max and min

DELETE FROM `#_assets` WHERE `id` >idnumber AND `id` < idnumber

1 user says Thank You to pavit for this useful post

1. nooran

[nooran Developer nooranJoin date: June 2013Posts: 119Downloads:8Uploads:21 Thanks: 32 Thanked: 6 times in 1 posts]

#534699

Hello pavit,

Now it worked fine… Many thanks to you

[Author]

Posts