Stewart's Algebra and Trigonometry: An Applied Approach is a fantastic textbook. It teaches everything normally in an A&T book, whilst also providing ways to apply what you're learning.
Another great feature is that there are modelling projects throughout the book, which are great to do as well.
All in all, it's one of the best A&T books I've read, that works wonders for students of the Physical Sciences.
You also mentioned that you know Pre-Algebra, so it would be worth having something on the level of Elementary Algebra and Intermediate Algebra, if you feel you need to bridge the gap to College Algebra level.
Normally, there's a lot of overlap between Elementary Algebra and Intermediate Algebra textbooks. I find having one of the combined ones work great, as I find there's not much overlap, as it picks up right after PreAlgebra, and ends right before College Algebra and Trigonometry.
For this book, I would highly recommend Tussy's combined Elementary and Intermediate Algebra - there's also a PreAlgebra, too. But, most books on Pre/Elementary/Intermediate Algebra will do, as it's more about learning the foundations and mathematical techniques. It's when you hit College Algebra, that I think you can normally find a book more tailored towards a certain area, such as a book like Stewart's Algebra and Trigonometry: An Applied Approach, which whilst covering everything an Algebra And Trigonometry book should, it also focusses on teaching the student how to apply the methods, along with giving you practice in modelling - this book will work wonders for when you start studying Calculus level textbooks.
Also, Stewart does a PreCalculus textbook (which I saw recommended earlier), but just so you know, this book is 99% identical to Stewart's Algebra and Trigonometry - I have literally sat down and compared, and it's word for word. The only difference is that the last chapter in Algebra and Trigonometry is Counting and Probability; whereas, PreCalculus has replaced this chapter with Limits, which you'll cover in the Calculus textbook anyway. So, saying that, you would benefit a lot more from Stewart's Algebra and Trigonometry, over Stewart's PreCalculus; especially, as you get the extra Counting and Probability chapter, which is definitely worth studying, along with the Limits chapter will be in the Calculus book anyway.
Just to add, both the Tussy and Stewart textbooks come with a ton of questions. You're talking like a hundred at the end of the chapters, and this isn't including the questions layered within the topics of the chapters. You're talking literally thousands per textbook.
I hope this helped?