Searching Text with MySQL

d80y6

New Member
I'm trying to tackle a PC parts listing for my website utilizing a MySQL database to make it easier on me in the long run...it's all going well until I need to do a bit of text searching.This is where I'm at:database name: _stafftable name: partsI need to SELECT * FROM itemName MATCH ("Processors:%");Essentially I need to find all rows in this table where the itemName column begins with "Processors:"The strings are colon delimited names preceded by [category]: .... if that is of any use :)Ideas?
 
Top