Forums WoW Modding Support Archives TrinityCore Discord Archives [DiscordArchive] ```UPDATE `creature_template` SET `minlevel` = 'minlevel - 10' WHERE `name` LIKE '%Amani\'shi%';

[DiscordArchive] ```UPDATE `creature_template` SET `minlevel` = 'minlevel - 10' WHERE `name` LIKE '%Amani\'shi%';

[DiscordArchive] ```UPDATE `creature_template` SET `minlevel` = 'minlevel - 10' WHERE `name` LIKE '%Amani\'shi%';

rektbyfaith
Administrator
Find
0
06-26-2024, 04:08 PM
#1
Archived author: Snowcraft • Posted: 2024-06-26T16:08:37.831000+00:00
Original source

```UPDATE `creature_template` SET `minlevel` = 'minlevel - 10' WHERE `name` LIKE '%Amani\'shi%';
UPDATE `creature_template` SET `maxlevel` = 'maxlevel - 10' WHERE `name` LIKE '%Amani\'shi%';```

Would these commands work, or am I getting some SQL syntax wrong here?
Reply
Reply
rektbyfaith
06-26-2024, 04:08 PM #1

Archived author: Snowcraft • Posted: 2024-06-26T16:08:37.831000+00:00
Original source

```UPDATE `creature_template` SET `minlevel` = 'minlevel - 10' WHERE `name` LIKE '%Amani\'shi%';
UPDATE `creature_template` SET `maxlevel` = 'maxlevel - 10' WHERE `name` LIKE '%Amani\'shi%';```

Would these commands work, or am I getting some SQL syntax wrong here?

Reply
Reply
rektbyfaith
Administrator
Find
0
06-26-2024, 04:09 PM
#2
Archived author: Snowcraft • Posted: 2024-06-26T16:09:29.328000+00:00
Original source

Or do I want ```UPDATE `creature_template` SET `minlevel` = minlevel - 10 WHERE `name` LIKE '%Amani\'shi%';
UPDATE `creature_template` SET `maxlevel` = maxlevel - 10 WHERE `name` LIKE '%Amani\'shi%';```?
Reply
Reply
rektbyfaith
06-26-2024, 04:09 PM #2

Archived author: Snowcraft • Posted: 2024-06-26T16:09:29.328000+00:00
Original source

Or do I want ```UPDATE `creature_template` SET `minlevel` = minlevel - 10 WHERE `name` LIKE '%Amani\'shi%';
UPDATE `creature_template` SET `maxlevel` = maxlevel - 10 WHERE `name` LIKE '%Amani\'shi%';```?

Reply
Reply
Recently Browsing
 1 Guest(s)
Recently Browsing
 1 Guest(s)