Find items using query

[tobi3591]

Hello everyone.
I can't quite remember what query to find specific items from items.
I have some rares that i want to move to different page in catalog_page

You must be registered for see images attach

 

[JynX]

SELECT * FROM `catalog_items` WHERE `item_id` = 'ID HERE';

You can find the ID HERE value by checking inside the furniture table for that specific item's ID.

 

[tobi3591]

SELECT * FROM `catalog_items` WHERE `item_id` = 'ID HERE';

You can find the ID HERE value by checking inside the furniture table for that specific item's ID.

Thanks,
what if i want to only search by name instead of ID? =)
Cheers

 

[Sledmore]

Find items:

SELECT * FROM `catalog_items` WHERE `page_id` = 'PAGE_ID';

Move items:

UPDATE `catalog_items` SET `page_id` = 'NEW_ID' WHERE `page_id` = 'OLD_ID'

Selecting catalog items based on name:

SELECT * FROM `catalog_items` WHERE `catalog_name` LIKE '%Spill%';

Important to note that having the wildcard between the word will technically look for 'containing' the word. You can adjust the query by removing a wildcard to search for before or after.

 

[tobi3591]

Find items:

SELECT * FROM `catalog_items` WHERE `page_id` = 'PAGE_ID';

Move items:

UPDATE `catalog_items` SET `page_id` = 'NEW_ID' WHERE `page_id` = 'OLD_ID'

Selecting catalog items based on name:

SELECT * FROM `catalog_items` WHERE `catalog_name` LIKE '%Spill%';

Important to note that having the wildcard between the word will technically look for 'containing' the word. You can adjust the query by removing a wildcard to search for before or after.

Thank you sir, helpmed me alot.

I request this threat closed, usefull comment =)

Cheers