Sql Query "Except" help!

08/19/2019 04:35 devdash#1

I want to delete weapons lines except blade lines so it should be like

PHP Code:


			
delete from _Table where _Column like 'WEAPON_CH%' except where _Column = 'WEAPON_CH_BLADE'

but it's not working like that, i tried google but no useful results found yet, so i hope if you guys have know how can i build that query...

Thanks in advance.

08/19/2019 08:02 JellyBitz#2

Except? Making exceptions?

You mean WHERE NOT? Think about how an IF condition works!

Quote:

DELETE FROM _Table
WHERE _Column LIKE 'WEAPON_CH%'
AND NOT _Column = 'WEAPON_CH_BLADE'

08/19/2019 10:00 Isoline*#3

Quote:

Originally Posted by alydandy

I want to delete weapons lines except blade lines so it should be like

PHP Code:

delete from _Table where _Column like 'WEAPON_CH%' except where _Column = 'WEAPON_CH_BLADE'

but it's not working like that, i tried google but no useful results found yet, so i hope if you guys have know how can i build that query...

Thanks in advance.

How about using Google before posting nonesene

08/19/2019 10:05 devdash#4

Quote:

Originally Posted by Isoline*

How about using Google before posting nonesene

How about reading before posting hate?!

Quote:

Originally Posted by alydandy

i tried google but no useful results found yet

Quote:

Originally Posted by JellyBitz

Except? Making exceptions?

You mean WHERE NOT? Think about how an IF condition works!

Thanks a lot for your post, i will try it now.

08/19/2019 10:08 Isoline*#5

Quote:

Originally Posted by alydandy

How about reading before posting hate?!

Thanks a lot for your post, i will try it now.

Its not hate its common sense, you can get the syntax of any query within seconds instead of posting here and waiting for someone to reply lol

08/19/2019 10:11 devdash#6

Quote:

Originally Posted by JellyBitz

Except? Making exceptions?

You mean WHERE NOT? Think about how an IF condition works!

Works perfectly, that's what i was looking for, thank you so much, and best wishes for your projects.

Quote:

Originally Posted by Isoline*

Its not hate its common sense, you can get the syntax of any query within seconds instead of posting here and waiting for someone to reply lol

Common sense tells me it was a hate, and now switched to Stubbornness,
but i will choose to believe you instead of my common sense, so..
Thanks for trying to help me and save my time by telling me about google, i appreciate it.

#Topic Close please.