Custom vendors, finding model ID's more.

[mufaka]

Im very new to antrix and sql as a whole. I understand how to query with "select" and "from" for example but I was wondering if there was a better way. If I'm looking for a specific item or vendor in a database and I know its name how do I query Ben Tobias or Travelers Backpack for example?

Im also interested in making some of those custom vendors spawn in stormwind and Orgimaar but I still need a little help figuring out how they place. If I put them in a bad place can they be moved or must I destroy them then readd them?

I have been looking for guides to all these things but cannot seem to find them. Even if you know of guides for me to search for I'd really appreciate it.

[MentaL]

[Ragefire89]

do it oldschool, go to the items table, organize it by name & scroll down/page flip untill you get to the item your looking for:console:

[channel_49]

select * from items where name = 'Ben Tobias';

or maybe even this:

select * from items where name contains '%Tobias%';